Using VBA Code To Hide and Unhide Sheets in Excel

[seuntoba]

Good Day Community,


I am looking for VBA Code on a project where i can use buttons to move between sheets. While moving between sheets i'll like only one sheet visible at any given time and use buttons to unhide and hide other sheets based on user action(button click)

Lets assume i have 4 main sheets - Main, Introduction, Discussion and Conclusion.


I will like to move from the Main sheet to the introduction sheet by clicking on a button in the "Main Sheet", for example Next.

When i get to the Introduction Sheet i'll like 2 buttons;

1- Back - Which returns to Main
2- Next - Which moves to the Discussion Sheet.
While doing this i'll like inactive sheets to be hidden


Under Discussion. i'll like 3 buttons
1- Back - returns to introduction
2. Home - Return to Main
3. Next - Moves to conclusion
While doing this i'll like inactive sheets to also be hidden


This way i can create many more sheets using the code. Everything i have tried has failed

 

[seuntoba]

Bump

 

[mikerickson]

Perhaps something like this

Sub NextSheet()
    Dim ActiveIndex As Long
    ActiveIndex = ActiveSheet.Index
    With ThisWorkbook
        .Sheets((ActiveIndex Mod (.Sheets.Count)) + 1).Visible = xlSheetVisible
        .Sheets(ActiveIndex).Visible = xlSheetHidden
    End With
End Sub

Sub PreviousSheet()
    Dim ActiveIndex As Long, PrevIndex As Long
    ActiveIndex = ActiveSheet.Index
    With ThisWorkbook
        PrevIndex = ActiveIndex - 1: If PrevIndex = 0 Then PrevIndex = .Sheets.Count
        .Sheets(PrevIndex).Visible = xlSheetVisible
        .Sheets(ActiveIndex).Visible = xlSheetHidden
    End With
End Sub

 

[seuntoba]

Thanks Mike, I haven’t tried this yet but is this code for each of my buttons or for the Worksheet Module?

 

[mikerickson]

On each sheet you would put two buttons, one labeled "Next Sheet", the other "Previous Sheet".

The Next Sheet buttons would be attached to the NextSheet macro and the Previous Sheet buttons attached to the PreviousSheet macro