Greg

To open a specific workbook just point your shortcut to that workbook or see
"Startup switches" in Excel's help.

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

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

Copy/paste this code 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, 29 Nov 2004 13:37:02 -0800, "greg"
wrote:

I am using Excel 2000. Is there a way to startup a workbook with a startup
switch that not only starts a specific workbook: but, also starts it up at a
specific tab within the workbook ?