Excel Macro?

Question

i have a workbook called 'test.xls' with worksheets 'pg1' and 'pg2'

can u giv a macro so dat wenever i open test.xls - pg1 is opened by default?

Thnx

Answer 1

Another option is to put code in the auto_close event that selects that sheet and saves the workbook before the close completes.

Put this code in a module of your workbook:
Sub auto_close()
'Selection code here.
'Save code here.
End Sub

Answer 2

You don't need a macro. Just drag the "pg1" tab to the left of the "pg2" tab at the bottom of the worksheets. This will produce the desired effect.

Also, you might like to learn to spell at some point.

Rawlyn.

Answer 3

Sub Auto_Open()
ActiveWorkbook. Worksheets("pg1"). Activate
End Sub