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 ?
Bookmarks