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.