Hello Excellers time for some Macro fun today. Let’s look at setting Excel to ALWAYS open at a specific work sheet or tab no matter what worksheet was active when the workbook was last closed and saved. This is especially handy if you have a workbook with a large number of worksheets. If you want to see all of the blog posts in the Macro Mondays Series you can do so by clicking on the link below.
If you want to download all of the examples used in the Macro Mondays series you can do so below.
Download Macro Mondays Example Files.
What Does The Macro Do?
This is a simple macro, which uses the workbook’s Open Event to start the workbook on the worksheet tab that we specify in the code.
How Does It Work?
FIRST. Open Visual Basic – by hitting ALT +F11 or Developer Tab, in the project window find your workbook name – click the + sign and to see all of the worksheets. Click ThisWorkbook and select the Open event in the Event drop down list.
Step 2. There is really one simple step in this Macro, to name the sheet tab you want Excel to open the workbook to. In my example I have chosen “MM22”
Step 3. Test your Macro!
Dont forget to SUBSCRIBE to the How To Excel At Excel Newsletter for more tips the first Wednesday of the month.