Hi,

I have the following code in a module

Sub goto_sheet()
Sheets("Thyristors").Select
End Sub
Sub back_to_sheet()
Sheets("Main Menu").Select
End Sub


On the Thyristors sheet I have a button that says Main menu, when clicked it takes me back to the Main menu.

On the Main Menu sheet I have button that says Thyristors, when clicked it takes me to the Thyristors worksheet.

I have identical modules for several worksheets so I can go back and to each sheet from the main menu.

I wanted to tidy up my spreadsheet and hide all the sheets other than the main menu sheet. But if I hide a sheet I then get an error when my macro buttons are used to open them.

What do I need to change to the code?

Many thanks for your help.