hide / unhide columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have approximately 10 columns that I want to hide or un-hide.

I was thinking of having associate text in B1 that may say hide column F
If A1 has an x it means hide column F
And associated text in B2 that may say un-hide column F
If A2 has an x it means un-hide column F

Another thought was to use radio buttons

The values in A1 and A2 are mutually exclusive.
That is, if A1 = x then A2 will not = x.
Same for A3 and A4.

The information will continue down to additional rows for each column I want
to hide or un-hide.
 
a more detailed explanation would be helpful but you could use a worksheet
change event with select case.
 
Back
Top