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
|