Table of Contents
In this Blog we will talk about How to set default Worksheets that show when a Workbook is open, using VBA.
Set the default worksheet when a workbook opens.
if we open a saved Excel workbook its shows the first sheet of the workbook or the sheet that active at the time of saving. If we want to set a default worksheet that shows when the workbook opens then you may need to do some steps and then you may write the code mentioned below.
Step -1: we have to first double click on “Thisworkbook” in the VBA editor window.
Step-2: Select Workbook in object Box and Choose the “Open” event.
Private Sub Workbook_Open() End Sub
Step-3: Write the below code Between the procedure of opening the workbook.
Private Sub Workbook_Open() Sheet3.Activate End Sub
This code is used for setting up the default sheet when a Workbook will open. you can use the above code to set the default sheet in the workbook when open instead default active sheet. We hope this will help you for clarification.