Tool Bars

  • Thread starter Thread starter PCOR
  • Start date Start date
P

PCOR

I have made myself a few very handy tool bars. Is there a EASY way to move
them from my computer to an other machine(s)-where are they stored?File
name?
Thanks
 
The full name depends on the excel version but it is always

*.xlb

if you want to search for it

There are many ways to do this, you can also have a macro that builds the
toolbar when you open a specific workbook and then resets customization off
when the workbook is closed. You can always reset the toolbars if nothing
else work by deleteting the xlb file
 
Most flexible way IMO is to create some VBA code to generate the toolbar on
workbook open, and delete it on close. You could always put it in
Personal.xls.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
using version 2003
Peo Sjoblom said:
The full name depends on the excel version but it is always

*.xlb

if you want to search for it

There are many ways to do this, you can also have a macro that builds the
toolbar when you open a specific workbook and then resets customization off
when the workbook is closed. You can always reset the toolbars if nothing
else work by deleteting the xlb file
Click to expand...
 
Back
Top