singingsister
Board Regular
- Joined
- Jun 13, 2006
- Messages
- 145
I have a large spreadsheet with a variety of macro "buttons" to hide various columns to only show certain data. What I need is to create a "reset" button, that is to say for which ever macro button someone has pressed, if they press the "reset" one, it will unhide all the columns.
How do I do it? Do I need to do a "reset" macro for each existing macro - to show the hidden columns or can I have one "reset" button that will show all regardless of what macro has been used.
How do I do it? Do I need to do a "reset" macro for each existing macro - to show the hidden columns or can I have one "reset" button that will show all regardless of what macro has been used.