in your projects window go to ThisWorkbook and in your code window''s left dropdown box choose WorkBook, Right dropdown box choose SheetActivate. Then put in this code

Private Sub Workbook_SheetActivate(ByVal Sh As Object) "this will be generated for you


If Sh.Name = "My Hide Sheet Name" Then Worksheets("My Default Sheet Name").Activat

End Sub "this will be generated for you


----- gav meredith wrote: ----

Hi

i have a workbook with which i want one of the sheets to not be viewe
without a password. Is this possible?? I dont simply want to hide the shee
as a person could unhide it. The contents of the sheet are not for all eyes

Any suggestions????? Cheers!!!