Worksheet Settings

[twiggy]

We now have XP on our company machines and the default setting when you open a new work book is to only open 1 sheet.

How do i change the settings so that ALL work books automatically open 3 sheets per book like the older versions of Excel? I am able to change the number of sheets for next new work book but afterwards it automatically reverts back to the old default.

I know how to do it in VB but i want this to be a general setting.

Regard

Twiggs

[Dav]

Do you mean tools_options_general Sheets in workbook=3 or something else

Regards

Dav

[Stefi]

Try Tools/Options/General tab/No of sheets in new workbook

Regards,
Stefi


„twiggy” ezt �*rta:

>
> We now have XP on our company machines and the default setting when you
> open a new work book is to only open 1 sheet.
>
> How do i change the settings so that ALL work books automatically open
> 3 sheets per book like the older versions of Excel? I am able to change
> the number of sheets for next new work book but afterwards it
> automatically reverts back to the old default.
>
> I know how to do it in VB but i want this to be a general setting.
>
> Regard
>
> Twiggs
>
>
> --
> twiggy
> ------------------------------------------------------------------------
> twiggy's Profile: http://www.excelforum.com/member.php...o&userid=34479
> View this thread: http://www.excelforum.com/showthread...hreadid=555509
>
>