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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
