very hidden sheets add-in

[spacecaptainsuperguy]

Hi everyone,
I used to have an excel add-in that had a form that allowed me to select multiple sheets from within that spreadsheet and select whether to hide, unhide or make very hidden the selected sheets. I recently upgraded my machine and office and that old add-in no longer works. I've searched the forum but haven't found anything quite like that in the VBA discussion. Anyone know of an add-in that provides that functionality or willing to share some code that performs that function? The code itself of hiding/unhiding (from what I've been looking at) doesn't seem like it is that involved, it's the user form and the functionality it provided, allowing me to select whatever sheets I needed that was the real time saver.
Thanks in advance.

 

[spacecaptainsuperguy]

Ya, toggle was what I was thinking. My assumption was you would have to do it with no password, but if that functionality can actually be built into it, then yes I use the same password on every sheet.

 

[Yongle]

Ok
I am busy for the next 48 hours - look for update after that

 

[spacecaptainsuperguy]

Sounds good. Thanks so much!

 

[spacecaptainsuperguy]

While I'm waiting on the generosity of Yongle, does anyone else have any thoughts on a macro that could serve this function? I'm guessing it would have to include a form of some sort to allow for the various options, selection of multiple sheets etc? Appreciate any ideas.