Hi

I need a spreadsheet to opne on the same sheet whenever it is opened. I use
to be able create a macro and name it Auto_run and it would automatically run
when the spreadsheet is opened but this Auto_run does not work in 2002
version of excel.

Have they cahnged the naming or is there amother simpler way to get it to do
what I want.

All help is much appreciated.

Cheers

PJ

Hi,

Use the inbuilt workbook_open event to select the sheet you want.
Alt+F11 to open editor. Doubleclick thisworkbook and paste this in:-

Private Sub Workbook_Open()
Sheets("MySheet").Select
End Sub

Mike

"PJ" wrote:

> Hi
>
> I need a spreadsheet to opne on the same sheet whenever it is opened. I use
> to be able create a macro and name it Auto_run and it would automatically run
> when the spreadsheet is opened but this Auto_run does not work in 2002
> version of excel.
>
> Have they cahnged the naming or is there amother simpler way to get it to do
> what I want.
>
> All help is much appreciated.
>
> Cheers
>
> PJ

By the way, the sub you're thinking of is Auto_open, not Auto_run

"Mike H" <(E-Mail Removed)> wrote in message
news:FC677B91-C1AA-4F04-B765-(E-Mail Removed)...
> Hi,
>
> Use the inbuilt workbook_open event to select the sheet you want.
> Alt+F11 to open editor. Doubleclick thisworkbook and paste this in:-
>
> Private Sub Workbook_Open()
> Sheets("MySheet").Select
> End Sub
>
> Mike
>
> "PJ" wrote:
>
>> Hi
>>
>> I need a spreadsheet to opne on the same sheet whenever it is opened. I
>> use
>> to be able create a macro and name it Auto_run and it would automatically
>> run
>> when the spreadsheet is opened but this Auto_run does not work in 2002
>> version of excel.
>>
>> Have they cahnged the naming or is there amother simpler way to get it to
>> do
>> what I want.
>>
>> All help is much appreciated.
>>
>> Cheers
>>
>> PJ