Open Specific Worksheet

C

cargor

When Excel opens, I would like a specific worksheet to
open. If someone could help i would be greatful!
 
T

tony h

in the workbook open event put in the code to activate the specific
sheet

worsheets("FrontSheet").activate

better still, I think, put it in the workbook close event. Then the
workbook is saved with the right sheet showing

regards
 
M

Marcelo

hi,

change the name of the workbook to personal.xls and copy it on the xlstart
directory

normaly at C:/program files/microsoft office/office11/xlstart

hth
regards from Brazil
Marcelo

"cargor" escreveu:
 
Top