View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Hide Sheet using Workbook Open Event

Hi John,

Try:

Private Sub Workbook_Open()
Worksheets("HelpSheet").Visible = xlSheetVeryHidden
End Sub


---
Regards,
Norman



wrote in message
ups.com...
I know this is simple, but I can't seem to get it to work. I want to
hide (make not visible) the HelpSheet worksheet. I was going to use
the WorkbookOpen event to make sure it is not visible each time the
workbook is opened.

Private Sub XL_WorkbookOpen(ByVal Wb As Workbook)
Worksheets("HelpSheet").Visible = xlSheetVeryHidden
End Sub

I have the above code in a class module. But the sheet is still
visible. Where did I go wrong?

Thanks,
John