That's one way. Or you could use a Worksheet_Change event
that will automatically hide certains columns once the
value has changed for a cell.
If you provide more detailed info (which columns to hide,
what is the target cell that changes values, etc), then
you'll probably get some code that'll work.
The way my sheet is set up, i want to be able to toggle
between hiding/unhiding the columns. Is there away to
associate a macro with a control button, or would i have
to use a button from the forms toolbar?
thanks for your advice
-matt
