Custom Toolbars - keep dissappearing

P

Paul S

I am using excel 2000

I recently created a custom toolbar with 4 custom buttons but no
cannot find the toolbar

I think this was caused by opening a file someone sent to me, which ha
re-set all my toolbars

How can I stop this happening

Pau
 
G

Gord Dibben

Re-build you toolbar then don't open files with macros enabled in the future.

Toolbar and menu customizations are stored in Excel9.xlb(2000 version)

Save a copy of that file so's you can restore if it gets changed.

Best method of assigning macros to buttons is to build the Toolbar when you open
the workbook and delete it when you close.

Do not make the changes to the existing toolbars.

See Debra Dalgleish's website for Dave Peterson help on building "on the fly"
toolbars and menus.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom VBA toolbar 0
Internal Data Integrity (Type 4) Details Needed 1
Multiple Custom Toolbars 3
VBA custom toolbar 3
how do we get 2003 .xlb toolbars and custom macros to show in 07 1
Toolbar keeps opening up other workbook tempaltes 0
Toolbar buttons to hide/unhide sheets 4
Excel 2003 - assign macro to custom toolbar button 1

Top