Open Specific Worksheet

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

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

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:

>
> When Excel opens, I would like a specific worksheet to
> open. If someone could help i would be greatful!
>
>
> --
> cargor
> ------------------------------------------------------------------------
> cargor's Profile: http://www.excelforum.com/member.php...o&userid=36300
> View this thread: http://www.excelforum.com/showthread...hreadid=560761
>
>

Thanks Tony

You need to use a VBA macro:

Sub Auto_Open()
ThisWorkbook.Worksheets("Sheet4").Select
End Sub

Change "Sheet4" to you desired worksheet.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"cargor" <cargor.2aucgg_1152722310.1062@excelforum-nospam.com>
wrote in message
news:cargor.2aucgg_1152722310.1062@excelforum-nospam.com...
>
> When Excel opens, I would like a specific worksheet to
> open. If someone could help i would be greatful!
>
>
> --
> cargor
> ------------------------------------------------------------------------
> cargor's Profile:
> http://www.excelforum.com/member.php...o&userid=36300
> View this thread:
> http://www.excelforum.com/showthread...hreadid=560761
>