I have a Master Workbook I use, and when I open it defaults to sheet 6 on open. Is there
a way to default to the last active sheet when the workbook name changes . So when
it not the master it opens on last active sheet?
If ThisWorkbook.Name <> "Master Invoice" Then Sheets("Sheet6").Select else last active sheet on close ?
Last edited by zplugger; 12-30-2011 at 05:05 PM.
All you'd need for that would be:
Otherwise it will open at the sheet it was on when last saved.If ThisWorkbook.Name = "Master Invoice" Then Sheets("Sheet6").Select
That did it.
Thank You
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks