Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 97 - Cannot delete custom toolbar from file
I am having problems trying to delete a custom toolbar
from my excel file. It should be a simple matter of deleting the toolbar from within the customise box, but this does not work. When I re-open the file the toolbar is created again. I have tried deleting the toolbar from the workspace instead of the file, but this does not work either There is no VBA code in the file that relates to manipulating any toolbars. This toolbar is also not created by an add-in, it is a toolbar that was created by a user of the excel file. How can I get rid of this customised toolbar? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 97 - Cannot delete custom toolbar from file
Sounds as though the bar is attached to the file.
To remove it, from the menu View Toolbars Customize : Click on "Attach" You should see at least one entry in the "Toolbars in workbook" list: click on it and then click on "Delete". Save your workbook, close it, reopen it, and the toolbar should have gone forever. -- Regards Andy Wiggins www.BygSoftware.com Home of "Save and BackUp", "The Excel Auditor" and "Byg Tools for VBA" "Mike O" wrote in message ... I am having problems trying to delete a custom toolbar from my excel file. It should be a simple matter of deleting the toolbar from within the customise box, but this does not work. When I re-open the file the toolbar is created again. I have tried deleting the toolbar from the workspace instead of the file, but this does not work either There is no VBA code in the file that relates to manipulating any toolbars. This toolbar is also not created by an add-in, it is a toolbar that was created by a user of the excel file. How can I get rid of this customised toolbar? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 97 - Cannot delete custom toolbar from file
Thanks. It worked.
The problem was that I was deleting the toolbar directly from the main menu instead of using the "attach" button -----Original Message----- Sounds as though the bar is attached to the file. To remove it, from the menu View Toolbars Customize : Click on "Attach" You should see at least one entry in the "Toolbars in workbook" list: click on it and then click on "Delete". Save your workbook, close it, reopen it, and the toolbar should have gone forever. -- Regards Andy Wiggins www.BygSoftware.com Home of "Save and BackUp", "The Excel Auditor" and "Byg Tools for VBA" "Mike O" wrote in message ... I am having problems trying to delete a custom toolbar from my excel file. It should be a simple matter of deleting the toolbar from within the customise box, but this does not work. When I re-open the file the toolbar is created again. I have tried deleting the toolbar from the workspace instead of the file, but this does not work either There is no VBA code in the file that relates to manipulating any toolbars. This toolbar is also not created by an add-in, it is a toolbar that was created by a user of the excel file. How can I get rid of this customised toolbar? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete a custom toolbar in excel 2007 from Add-Ins | Setting up and Configuration of Excel | |||
How do I permanently delete a custom toolbar in Excel? | Excel Worksheet Functions | |||
I would like to delete a custom toolbar from the workspace. How? | Setting up and Configuration of Excel | |||
How to permanently delete a custom toolbar? | Excel Programming | |||
delete custom toolbar | Excel Programming |