LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
twiggy
 
Posts: n/a
Default Worksheet Settings


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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2003 Shared Worksheet Protection Settings Failing For My 2000 User JWarnick-SHH Excel Worksheet Functions 0 March 17th 06 06:59 PM
Inserting Filtered RC cell information into other worksheets Dennis Excel Discussion (Misc queries) 10 July 30th 05 01:54 AM
Search/Match between 2 x separate Worksheets and populate result in third worksheet Alan Bartley Excel Discussion (Misc queries) 1 April 11th 05 05:21 AM
Copy from worksheet to another x times Union70 Excel Discussion (Misc queries) 0 March 7th 05 09:03 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


All times are GMT +1. The time now is 12:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"