Deleted Custom Toolbar keeps returning.

  • Thread starter Thread starter Paul Martin
  • Start date Start date
P

Paul Martin

Hi guys

I am having a problem with a deleted custom toolbar that keeps
returning when I start up Excel (2003).

* I have a custom toolbar with various developer productivity tools
that I have developed.
* The code that is executed by the buttons is in PERSONAL.XLS.
* I am working for a company and would like to deploy a custom toolbar
similar to my own one.
* I have copied PERSONAL.XLS as BSJIU.XLS and removed PERSONAL.XLS
from the XLSTART folder (with BSJIU.XLS remaining in its place).
* I have assigned the macros behind each button to the new file.
* In Tools, Customise, Toolbars, I have deleted the original custom
toolbar (I have given the two versions different names).

Yet at start up of Excel, the old custom toolbar keeps returning. Any
suggestions of how to remedy this are appreciated.

Thanks in advance

Paul Martin
Melbourne, Australia
 
I should also add that I'm looking for an Excel interface solution,
not a VBA solution (though I suppose a VBA solution is OK if it fixes
the problem permanently).

Paul
 
Here are three possible reasons why your bar keeps returning

- The bar is re-created programmatically in the load event of some workbook
or addin.

- You had another Excel instance open when you deleted the bar in the first.
If the second instance is closed after the first, the toolbar folder will be
resaved and include your toolbar (which was not deleted in that instance)

- The toolbar is "Attached" to some workbook or addin. It will re-appear
when the file it is attached to re-opens

The solution to permanently remove the toolbar will of course depend on why
it returns.

Regards,
Peter T
 
Back
Top