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

---
HTH
Roger
Shaftesbury (UK)
(Excel 2003, Win XP/SP2)



"AJ" wrote in message
...
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.