Question Startup Switches
 

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 ?

Not through a startup switch.

But you could have a macro that selects the desired worksheet when you open the
workbook.

option explicit
sub auto_open()
worksheets("my startup sheet").select
end sub

(don't forget to change the worksheet name to what you want.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

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 ?

--

Dave Peterson

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 ?