View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
appeng appeng is offline
external usenet poster
 
Posts: 9
Default hide / unhide columns

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.