Hide and unhide using VBA

[abid hussain]

Dear Sir,
Hope you are doing well !
I am trying to hide and unhide all the sheets except the "MAIN" sheet. The sheet should be hidden again once the "return to HOME" text box is selected. The main dashboard can stay active all the time.
Hope to get your help.

Warm Regards

 

[vletm]

abid hussain​

You've opened already duplicated two times same thread:

HIDING

Dear All I need help as I am trying to hide all the "sheets" having hyperlink except the "MAIN" sheets when my file is opened and unhide each worksheet when a text box with a hyperlink is selected. The sheet should be hidden again once the "return to menu" text box is selected. The main...

chandoo.org

hide all worksheets having hyperlink except the "MASTER"

Sir I need your help once again as I am trying to hide all worksheets having hyperlink except the "MASTER" when my file is opened and unhide each worksheet when a text box with a hyperlink is selected. The sheet should be hidden again once the "return to menu" text box is selected. The main...

chandoo.org

You've already got a solution which You could use with this.
Is there any reason, why do You ask someone else to do same again instead to do it Yourself?

 

[abid hussain]

Yes, I try to do myself but unable to do so. That's why I am seeking help.

 

[vletm]

So this is duplicated again.
This thread have to close.
Show in Your previous not closed cell ... what have You tried to do?
... with Excel-format-file.