View Single Post
  #3   Report Post  
Smuggy
 
Posts: n/a
Default

Ken

Your toolbar customisation is saved in a file called either Excel.xlb or
Excel1.xlb.

If you wanted to have multiple toolbar settings that you can switch between
suggest you set up in Excel the way you want, exit and then copy and rename
the above .xlb file to, for example, option1.xlb - then repeat with the
different settings you want and repeat with each file renamed differently
option2.xlb etc.

When you open Excel - it should defaul to the Excel.xlb filename - you can
override this with File - Open - Files of Type - Toolbars (.xlb) and open one
of your options above.

Steve

"Ken" wrote:

In Word I can save the normal template so on reformatting I have all my
personal toolbars/ cutomisations. Is there anything similar I can do with
Excel.

Thanks in anticipation

Ken