Where are toolbars kept?

  • Thread starter Thread starter Francis Hookham
  • Start date Start date
F

Francis Hookham

In Word toolbars and macros are kept in the Normal template

1
In XL where are my custom toolbars kept?
Not in the Personal Macro Workbook nor, I think, in the Workbook1 template

2
At my age I forget easily although it is an often answered question - please
remind me how to save the Workbook1 template - the default in 2004.11.2 is
irritatingly in Page Layout View rather than Normal view

Francis Hookham
 
Toolbar file is called *xlb (depending on the excel version, 2003 is
Excel11.xlb)
Excel 2004 is for Mac and I don't know where the template is stored, in
windows you would create a workbook and save it as Book.xlt in the startup
folder (Xlstart)

--
Regards,

Peo Sjoblom

Portland, Oregon
 
Hi, Francis,

1) Since you're referring to Personal Macro Workbook, I'll assume you're
referring to MacXL. Toolbars are stored in the

~:Library:Preferences:Microsoft:Excel Toolbars (11)

file (where ~ is your home directory).

2) Configure your workbook as desired (number of sheets, view,
formatting, etc). Save it *as an XL Template* with the name "Workbook"
(no quotes, no extension) in the

HD:Applications:Microsoft Office 2004:Office:Startup:Excel:

folder. This is explained in the "default workbook template" topic in XL
Help.

However, you don't need to do that just to change the default from Page
Layout View to Normal. You can set that preference with
Preferences/View, selecting, Normal from the "Open new worksheets using
this view" dropdown.
 
Back
Top