Hide Sheet when another sheet is chosen

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I have a workbook with just two work sheets.
Sheet 1 is the one with details and is hidden unless I need to update it.
Sheet 2 is the one being used most of the time.

What I would like to do is to write a code that after I update the data in
Sheet 1 and when I select Sheet 2 to use it, Sheet 1 must be hidden (and
remain hidden) until the time I unhide using the normal Unhide command in the
Format Menu.

Thanks in advance for your help.
 
In the VBA Module for Sheet1, enter

Sheets("Sheet1").Visible = False

in the Worksheet_Deactivate event.

Your finished code will look like:

Private Sub Worksheet_Deactivate()
Sheets("Sheet1").Visible = False
End Sub
 
Hello
I have a workbook with just two work sheets.
Sheet 1 is the one with details and is hidden unless I need to update it.
Sheet 2 is the one being used most of the time.

What I would like to do is to write a code that after I update the data in
Sheet 1 and when I select Sheet 2 to use it, Sheet 1 must be hidden (and
remain hidden) until the time I unhide using the normal Unhide command in the
Format Menu.

Thanks in advance for your help.
Click to expand...

The most simple way to do this is with a macro in Sheet1
and then use the code:

Private Sub Worksheet_Deactivate()
Worksheets(1).Visible = xlSheetHidden
End Sub

greetings

Steven
 
Back
Top