View Single Post
  #2   Report Post  
shajueasow
 
Posts: n/a
Default

If you want to select sheet3 then use this code in Workbook Open() module

Sheets("Sheet3").Select

Change the sheet3 to whatever sheet name you want to be selected first,
while the workbook is opened.
"IGA" wrote:

When I open a workbook, it always does with SHEET 1. How do I start it with a
worksheet other than SHEET 1? I think it is useful when renaming the
worksheets.

Thanks