Start at sprcific sheet every time opened

W

wx4usa

Is there a way to automatically open a specified sheet each time a
workbook is opened?

I want sheet 1 opened upon opening a workbook.
 
R

RichardSchollar

Hi

Yes there is - you need to add some code to the ThisWorkbook module of
the workbook concerned. You do this via the Visual Basic Editor
accessible via Alt+F11. Navigate to your workbook in the top left
Projects pane, and double-click on the ThisWorkbook module. Paste the
following code into the code pane which will appear to the right:

Private Sub Workbook_Open()
Sheets("Sheet1").Activate
End Sub

and that's it! You need to save this down, then when you open the
workbook (and Enable macros, if you are on Medium security), Sheet1
will be visible.

Hope this helps!

Richard
 
D

Don Guillett

right click the xl logo in the upper left of the screen>view code>left
window workbook>right window>

sheet1.select
 
W

wx4usa

Richard, Thanka a bunch! This helps!

Hi

Yes there is - you need to add some code to the ThisWorkbook module of
the workbook concerned. You do this via the Visual Basic Editor
accessible via Alt+F11. Navigate to your workbook in the top left
Projects pane, and double-click on the ThisWorkbook module. Paste the
following code into the code pane which will appear to the right:

Private Sub Workbook_Open()
Sheets("Sheet1").Activate
End Sub

and that's it! You need to save this down, then when you open the
workbook (and Enable macros, if you are on Medium security), Sheet1
will be visible.

Hope this helps!

Richard
Click to expand...
 
Top