Autohide worksheet when when not active

[LC_AU]

I want a couple of worksheets to automatically hide when they are not active.
I currently have a "go to" button which calls the sheet when I need it but I want these worksheets to be hidden when the user moves to another sheet.

Can you please kindly help

Thank you

 

[tygrrboi]

In the code for each worksheet you want this in...

Private Sub Worksheet_Deactivate()
Me.Visible = xlVeryHidden
End Sub

But now you need to make sure you are not only activating the sheet you want in the "go to" button but also setting it to visible.

 

[LC_AU]

That's perfect! Thank you!