Dave

To open at a specific sheet you would need to save the workbook at that sheet
or activate that sheet upon opening the workbook.

Private Sub Workbook_Open
Sheets("MySheet").Activate
'if want a specific cell add
Range("G23").Select
End Sub

OR select when you save the workbook.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("MySheet").Activate
'if want a specific cell add
Range("G23").Select
End Sub

Copy/paste either of the above to the ThisWorkbook module.

With workbook open hit ALT + F11 to get to Visual Basic Editor. CRTL + r to
open Project Explorer.

Find your workbook/project and expand the MS Excel Objects.

Double-click on ThisWorkbook to open.

Paste the code in there.

ALT + Q to go back to Excel window.

Make sure the workbook Security is set to "Medium" under
ToolsOptionsSecurityMacro Security.

Save.


Gord Dibben Excel MVP

On Mon, 2 May 2005 11:39:01 -0700, "Dave"
wrote:

Is there a way to have a workbook open to a certain worksheet regardless of
which worksheet was active when the file was saved and clsoed?

Example:
Worksheets in workbook - data, budget, analysis, comments

Saved and closed with data worksheet active

On open have budget worksheet active

Thanks