hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,226
- Office Version
- 2010
- Platform
- Windows
- Mobile
I am using Excel 2007 with real time feeds in 1 of its worksheet. 4 'different' worksheet tab named 'M'; 'M2'; 'M3' & 'M4' are also there but without any macros in it. Due to space constraint in these 4 ws I have been keeping the column widths of the cells as small as required but some extra help is now needed....in these 4 ws.
Goal: In these 4 ws; to 'make' the column width of columns C, D, E, F & G EQUAL to 0 provided C60=1; D60=1; E60=1; F60=1 & G60=1 is found respectively.
Example:
If C60=1 D60 NOT EQUAL TO 1; E60=1 F60=1 & D60 NOT EQUAL TO 1;
Then column width of columns C, E & F should become equal to 0. Now again if C60 (is made not equal to 1) by punching any value other than 1, say,5 so that C60=5; the column width should get restored back to its "previous width which has been set" before C60 was punched manually equal to 1.
Thanx in adv
Goal: In these 4 ws; to 'make' the column width of columns C, D, E, F & G EQUAL to 0 provided C60=1; D60=1; E60=1; F60=1 & G60=1 is found respectively.
Example:
If C60=1 D60 NOT EQUAL TO 1; E60=1 F60=1 & D60 NOT EQUAL TO 1;
Then column width of columns C, E & F should become equal to 0. Now again if C60 (is made not equal to 1) by punching any value other than 1, say,5 so that C60=5; the column width should get restored back to its "previous width which has been set" before C60 was punched manually equal to 1.
Thanx in adv