Main sheet tab

maxwel · Aug 13, 2011

How would I set by default opening my worksheet file which goes directly to main tab where all my dash board are plotted and not on the sub tab?

Hui · Aug 14, 2011

Copy the following subroutine to the ThisWorkbook Module in VBA (Alt F11)

Change the Sheet name and Starting range to suit

[pre]

Code:

Private Sub Workbook_Open()
Sheets(&#34;Main&#34;).Select
Range(&#34;D10&#34;).Select
End Sub

[/pre]

Save the file as a *.xlsm

Every time you open it, it will go directly to Main!D10