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.

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


wx4usa wrote:
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.

right click the xl logo in the upper left of the screenview codeleft
window workbookright window

sheet1.select

--
Don Guillett
SalesAid Software

"wx4usa" wrote in message
ups.com...
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.

Richard, Thanka a bunch! This helps!

On Jan 21, 11:30 am, "RichardSchollar"
wrote:
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

wx4usa wrote:
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.