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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks