Unhide multiple worksheets at once
We can hide several worksheets at once, but we can only show them individually.
Although the VBA can solve this issue with some lines of code, but it would be a great improvement if you add this capability to Excel as a build in feature.
Jamie McIntyre commented
I like this one too.
Perhaps it could be merged with this suggestion which has another 200 votes at the moment?
It's so tantalizingly close too. All the architecture is there, or literally almost all. A selection box is available with the hidden sheets listed... IF ONLY we could select more than one at a time... it seems like such simple code to add.
A teeny, tiny piece of code... and standard stuff too, where the current code flouts usual practice of:
1. Double-click on a single one to instantly act on it ignoring all others, or
2. Ctrl-click on individual items to make out a selection list one by one, inside the box, or
3. Shift-click to select several contiguous choices
so someone had to not only decide to do it against the norm, but to do the work of carefully coding to do so instead of copying and pasting standard selection code. (Sigh...)
Khris F. commented
PLEASE ADD THIS
Marc Labrie commented
It would make my day much easier...
This would be immensely helpful.