View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Q - Open Specific Sheet

Try worksheets with an s on the end.

Application.ScreenUpdating = False
Worksheets("Header").Activate
--
Regards,

OssieMac


"Seanie" wrote:

I have the code below under ThisWorkbook, but it returns an error
"Compile Error in Hidden Module: ThisWorkbook" - why is that? My sheet
"Header" is not hidden, although I do have other sheets hidden

Private Sub Workbook_Open()

Application.ScreenUpdating = False
Worksheet("Header").Activate

End Sub