Hiding

[abid hussain]

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 dashboard can stay active all the time

Regards
Abid Hussain

 

[Luke M]

You will need to create a unique macro for each button on the main sheet that unhides the destination sheet and then navigates to it. For the Workbook_Open event and all the 'Return to Menu' boxes, you can use a macro like

Private Sub Workbook_Open()
    Dim ws As Worksheet
    
    'Prevent screen flicker
    Application.ScreenUpdating = False
    
    For Each ws In ThisWorkbook.Worksheets
        If ws.Name <> "MAIN" Then
            ws.Visible = xlSheetHidden
        End If
    Next ws
    
    Application.ScreenUpdating = True
End Sub

 

[vletm]

abid hussain​

You duplicated this thread fourth time.

Hide and unhide using VBA

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

chandoo.org

You've already two solutions with the 1st thread.
Is there any reason, why You skipped both of those
... hyperlinks won't solve Your case.

With previous duplicated thread, I asked You to show - what have You tried to do?
... I'm still waiting for Your reply with that thread which is open.
Because duplication, this thread gotta close too.

abid hussain​

Here one more time a sample - which shows possible way to solve this.

Luke M​

There need to be one macro for all those buttons.
It can use buttons name for opening needed sheet.