Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleted Custom Toolbar keeps returning.
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleted Custom Toolbar keeps returning.
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleted Custom Toolbar keeps returning.
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 "Paul Martin" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleted Custom Toolbar keeps returning.
Thanks, Peter. It was attached. It's working fine now.
Regards Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
deleted text character returning numbers when deleted. | New Users to Excel | |||
Resorting Deleted Menu/Toolbar | Excel Discussion (Misc queries) | |||
Formulas returning errors when reference columns are deleted | Excel Programming | |||
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! | Excel Programming | |||
saving toolbar buttons on custom toolbar | Excel Programming |