Unhide sheets

[Irina]

Hello to everybody,

Is there any way to unhide several hidden sheets simulteneously? Sometimes I need to unhide a lot of hidden sheets and it irritates when you have to do it one by one.

Thanks a lot in advance,

Irina.

[dominicb]

Good morning Irina

You can download my free add-in via the link below. It can hide / unhide one, some or all* sheets at once. Once installed just go to Ultimate > Sheets > Hidden Sheet Manager.

* All except one sheet of course, 'cos at least one sheet has to be visible at all times ...

HTH

DominicB

[Irina]

Good morning Irina

You can download my free add-in via the link below. It can hide / unhide one, some or all* sheets at once. Once installed just go to Ultimate > Sheets > Hidden Sheet Manager.

* All except one sheet of course, 'cos at least one sheet has to be visible at all times ...

HTH

DominicB

Thank you sir,

Unfortunately we are not allowed to download any executive file, but I got the idea, I will write a macro. I just was trying to find standard MS decision.
Something like shift+ or ctrl+.

Thank you again, have a nice morning.

[VBA Noob]

Hi,

If it's the same sheets each time try something like this and add to a macro button

Please Login or Register  to view this content.

VBA Noob

[Irina]

Hi,

If it's the same sheets each time try something like this and add to a macro button

Please Login or Register  to view this content.

VBA Noob

Thank you.

[VBA Noob]

No Problem

VBA Noob