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