View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don J Don J is offline
external usenet poster
 
Posts: 6
Default How to start Excel on a specific Worksheet.

I don't know how to do this. What is the 'Workbook.Open' event? Also where
is the 'Object Module', and what is 'ThisWorkbook'?

Don J

------------------------------------------------------------------------------
"JMay" wrote in message
...
Use the Workbook.Open event in the Object Module ThisWorkbook

Private Sub Workbook_Open()
Sheets("MyWorksheetName").Activate
End Sub


"Don J" wrote in message
:

I always want Excel to start on a specific Worksheet whenever I open a
particular Workbook. How can I do that?

Don J

-----------------------------------------------------