In network installations Excel usually makes itself a folder under the user
profile, (in my case)
C:\Documents and Settings\Nick Hodge\Application Data\Microsoft\Excel\
In XP this folder is hidden below the user name. Below this folder is one
called XLStart. If you set up Excel as you want it to open and save the
file in this folder as a template called Book.xlt and then do the same with
a file saved as a template called Sheet.xlt. Excel will open with these
settings (Book.xlt) and it will also apply to any sheets added subsequently
to the workbook (sheet.xlt). They are in effect user-defined start-up
templates
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
