| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I permanently delete a custom toolbar in Excel?
I keep deleting the custom toolbar, even after unhiding the personal.xls
worksheet and saving changes, but it keeps coming back when I re-open Excel. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I permanently delete a custom toolbar in Excel?
What version of Excel are you running?
Personal.xls has not been used to create custom toolbars/menus since the introduction of Excel 97. Although you may have code in Personal.xls that builds the Toolbar when you open Excel. If that's not the case then read on. Toolbar Customizations are now stored in your Excelxx.xlb file. Try ToolsCustomizeToolbars. Select the one you don't want and delete it. From another post on this subject.................... If the workbook in question was constructed using XL95 which had the "Menu Editor" feature the Menu Items will continue to reappear even though there are no Macros associated with them. This feature(Menu Editor)was dumped with XL97 and up. Jim Rech has written RemoveMenu.XLA which gets rid of these. Can be found on Stephen Bullen's site. http://www.oaltd.co.uk/MVP/Default.htm Gord Dibben MS Excel MVP On Thu, 26 Jul 2007 12:50:03 -0700, Argee wrote: I keep deleting the custom toolbar, even after unhiding the personal.xls worksheet and saving changes, but it keeps coming back when I re-open Excel. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I permanently delete a custom toolbar in Excel?
Thanks for your response Gord.
I am running Excel 2003. My problem started when I upgraded to Vista and had to copy my macros and custom toolbars over to work in the new OS. The macros couldn't find the files I was referring to as they were now in a different path. I ended up having to rewrite the macros to get them working again. From your repsonse, I tried deleting the Excel11.xlb file and opened the Personal.xls file, deleted the toolbar (ToolsCustomizeToolbars), hid Personal.xls and saved it. Reopened Excel and the toolbar is still there. Glenn "Gord Dibben" wrote: What version of Excel are you running? Personal.xls has not been used to create custom toolbars/menus since the introduction of Excel 97. Although you may have code in Personal.xls that builds the Toolbar when you open Excel. If that's not the case then read on. Toolbar Customizations are now stored in your Excelxx.xlb file. Try ToolsCustomizeToolbars. Select the one you don't want and delete it. From another post on this subject.................... If the workbook in question was constructed using XL95 which had the "Menu Editor" feature the Menu Items will continue to reappear even though there are no Macros associated with them. This feature(Menu Editor)was dumped with XL97 and up. Jim Rech has written RemoveMenu.XLA which gets rid of these. Can be found on Stephen Bullen's site. http://www.oaltd.co.uk/MVP/Default.htm Gord Dibben MS Excel MVP On Thu, 26 Jul 2007 12:50:03 -0700, Argee wrote: I keep deleting the custom toolbar, even after unhiding the personal.xls worksheet and saving changes, but it keeps coming back when I re-open Excel. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I permanently delete a custom toolbar in Excel?
With Excel closed.
Move Personal.xls out of your XLSTART folder temporarily. Delete the *.xlb file. Re-start Excel. If no Toolbar, work back from there to see how the Toolbar is being created. Is it possible that Personal.xls contains code that builds the Toolbar or perhaps the Toolbar is attached to Personal.xls? Unhide Personal.xls and ToolsCustomizeToolbarsAttach. Unattach if one is in the attached section. Save Personal.xls Gord On Fri, 27 Jul 2007 09:00:01 -0700, Argee wrote: Thanks for your response Gord. I am running Excel 2003. My problem started when I upgraded to Vista and had to copy my macros and custom toolbars over to work in the new OS. The macros couldn't find the files I was referring to as they were now in a different path. I ended up having to rewrite the macros to get them working again. From your repsonse, I tried deleting the Excel11.xlb file and opened the Personal.xls file, deleted the toolbar (ToolsCustomizeToolbars), hid Personal.xls and saved it. Reopened Excel and the toolbar is still there. Glenn "Gord Dibben" wrote: What version of Excel are you running? Personal.xls has not been used to create custom toolbars/menus since the introduction of Excel 97. Although you may have code in Personal.xls that builds the Toolbar when you open Excel. If that's not the case then read on. Toolbar Customizations are now stored in your Excelxx.xlb file. Try ToolsCustomizeToolbars. Select the one you don't want and delete it. From another post on this subject.................... If the workbook in question was constructed using XL95 which had the "Menu Editor" feature the Menu Items will continue to reappear even though there are no Macros associated with them. This feature(Menu Editor)was dumped with XL97 and up. Jim Rech has written RemoveMenu.XLA which gets rid of these. Can be found on Stephen Bullen's site. http://www.oaltd.co.uk/MVP/Default.htm Gord Dibben MS Excel MVP On Thu, 26 Jul 2007 12:50:03 -0700, Argee wrote: I keep deleting the custom toolbar, even after unhiding the personal.xls worksheet and saving changes, but it keeps coming back when I re-open Excel. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I permanently delete a custom toolbar in Excel?
Thanks Gord.
I moved Personal.xls to the desktop and deleted the .xlb file. Excel starts with no custom toolbars or macros (i.e. virgin state). A new .xlb file is created upon exiting Excel. Re-opening Excel give the same virgin state. Opening Personal.xls from desktop opens Excel with no worksheet showing (personal is a hidden file) but the Custom toolbar is there. My second (desired) toolbar is not there but the macros related to it are. I found the toolbar attached to the worksheet and deleted the attachment as you suggested. I then deleted the toolbar again from the Customize dialog (list of toolbars) and it appears to be working properly now. Thanks very much for your help! "Gord Dibben" wrote: With Excel closed. Move Personal.xls out of your XLSTART folder temporarily. Delete the *.xlb file. Re-start Excel. If no Toolbar, work back from there to see how the Toolbar is being created. Is it possible that Personal.xls contains code that builds the Toolbar or perhaps the Toolbar is attached to Personal.xls? Unhide Personal.xls and ToolsCustomizeToolbarsAttach. Unattach if one is in the attached section. Save Personal.xls Gord On Fri, 27 Jul 2007 09:00:01 -0700, Argee wrote: Thanks for your response Gord. I am running Excel 2003. My problem started when I upgraded to Vista and had to copy my macros and custom toolbars over to work in the new OS. The macros couldn't find the files I was referring to as they were now in a different path. I ended up having to rewrite the macros to get them working again. From your repsonse, I tried deleting the Excel11.xlb file and opened the Personal.xls file, deleted the toolbar (ToolsCustomizeToolbars), hid Personal.xls and saved it. Reopened Excel and the toolbar is still there. Glenn "Gord Dibben" wrote: What version of Excel are you running? Personal.xls has not been used to create custom toolbars/menus since the introduction of Excel 97. Although you may have code in Personal.xls that builds the Toolbar when you open Excel. If that's not the case then read on. Toolbar Customizations are now stored in your Excelxx.xlb file. Try ToolsCustomizeToolbars. Select the one you don't want and delete it. From another post on this subject.................... If the workbook in question was constructed using XL95 which had the "Menu Editor" feature the Menu Items will continue to reappear even though there are no Macros associated with them. This feature(Menu Editor)was dumped with XL97 and up. Jim Rech has written RemoveMenu.XLA which gets rid of these. Can be found on Stephen Bullen's site. http://www.oaltd.co.uk/MVP/Default.htm Gord Dibben MS Excel MVP On Thu, 26 Jul 2007 12:50:03 -0700, Argee wrote: I keep deleting the custom toolbar, even after unhiding the personal.xls worksheet and saving changes, but it keeps coming back when I re-open Excel. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I permanently delete a custom toolbar in Excel?
Long way around but glad you're sorted
Gord On Fri, 27 Jul 2007 13:02:01 -0700, Argee wrote: Thanks Gord. I moved Personal.xls to the desktop and deleted the .xlb file. Excel starts with no custom toolbars or macros (i.e. virgin state). A new .xlb file is created upon exiting Excel. Re-opening Excel give the same virgin state. Opening Personal.xls from desktop opens Excel with no worksheet showing (personal is a hidden file) but the Custom toolbar is there. My second (desired) toolbar is not there but the macros related to it are. I found the toolbar attached to the worksheet and deleted the attachment as you suggested. I then deleted the toolbar again from the Customize dialog (list of toolbars) and it appears to be working properly now. Thanks very much for your help! "Gord Dibben" wrote: With Excel closed. Move Personal.xls out of your XLSTART folder temporarily. Delete the *.xlb file. Re-start Excel. If no Toolbar, work back from there to see how the Toolbar is being created. Is it possible that Personal.xls contains code that builds the Toolbar or perhaps the Toolbar is attached to Personal.xls? Unhide Personal.xls and ToolsCustomizeToolbarsAttach. Unattach if one is in the attached section. Save Personal.xls Gord On Fri, 27 Jul 2007 09:00:01 -0700, Argee wrote: Thanks for your response Gord. I am running Excel 2003. My problem started when I upgraded to Vista and had to copy my macros and custom toolbars over to work in the new OS. The macros couldn't find the files I was referring to as they were now in a different path. I ended up having to rewrite the macros to get them working again. From your repsonse, I tried deleting the Excel11.xlb file and opened the Personal.xls file, deleted the toolbar (ToolsCustomizeToolbars), hid Personal.xls and saved it. Reopened Excel and the toolbar is still there. Glenn "Gord Dibben" wrote: What version of Excel are you running? Personal.xls has not been used to create custom toolbars/menus since the introduction of Excel 97. Although you may have code in Personal.xls that builds the Toolbar when you open Excel. If that's not the case then read on. Toolbar Customizations are now stored in your Excelxx.xlb file. Try ToolsCustomizeToolbars. Select the one you don't want and delete it. From another post on this subject.................... If the workbook in question was constructed using XL95 which had the "Menu Editor" feature the Menu Items will continue to reappear even though there are no Macros associated with them. This feature(Menu Editor)was dumped with XL97 and up. Jim Rech has written RemoveMenu.XLA which gets rid of these. Can be found on Stephen Bullen's site. http://www.oaltd.co.uk/MVP/Default.htm Gord Dibben MS Excel MVP On Thu, 26 Jul 2007 12:50:03 -0700, Argee wrote: I keep deleting the custom toolbar, even after unhiding the personal.xls worksheet and saving changes, but it keeps coming back when I re-open Excel. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you permanently change toolbar from default setting in exce | Excel Discussion (Misc queries) | |||
| How can we delete rows permanently from excel sheet | Excel Discussion (Misc queries) | |||
| How to permanently customize a toolbar?? | Excel Discussion (Misc queries) | |||
| how do I add sum function to the toolbar permanently | Excel Discussion (Misc queries) | |||
| I would like to delete a custom toolbar from the workspace. How? | Setting up and Configuration of Excel | |||
Hybrid Mode
