Tool Bars

[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

 

[Peo Sjoblom]

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

 

[Bob Phillips]

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)

 

[PCOR]

using version 2003

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

 

[Peo Sjoblom]

Excel11.xlb

--

Regards,

Peo Sjoblom

using version 2003