View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 422
Default How to start Excel on a specific Worksheet.

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

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