Hi all,
Would love help on this. I've found lots of code online that come close to this, but I can't quite tweak it to be as simple as this should be.
I have a file with about 5-6 visible sheets and 9-10 hidden sheets. I would like to set up 2 macros.
#1. to take a look at, and remember how it is currently set up (which tabs are visible/hidden and which cells are the active cells on each), then to unhide all sheets. I was thinking an easy way might be to create a new sheet to temporarily store this info.
#2. to put everything back to how it was before the sheets were unhidden.
Can anyone help?
Would love help on this. I've found lots of code online that come close to this, but I can't quite tweak it to be as simple as this should be.
I have a file with about 5-6 visible sheets and 9-10 hidden sheets. I would like to set up 2 macros.
#1. to take a look at, and remember how it is currently set up (which tabs are visible/hidden and which cells are the active cells on each), then to unhide all sheets. I was thinking an easy way might be to create a new sheet to temporarily store this info.
#2. to put everything back to how it was before the sheets were unhidden.
Can anyone help?