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.

a more detailed explanation would be helpful but you could use a worksheet
change event with select case.


--
Don Guillett
SalesAid Software
donaldb@281.com
"appeng" <appeng@discussions.microsoft.com> wrote in message
news:0F81222B-19C7-446B-85C6-09AF16DAD102@microsoft.com...
> 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.
>