How do I permanently delete a custom toolbar in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 Tools>Customize>Toolbars.

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
 
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 (Tools>Customize>Toolbars), hid
Personal.xls and saved it. Reopened Excel and the toolbar is still there.

Glenn
 
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 Tools>Customize>Toolbars>Attach.

Unattach if one is in the attached section.

Save Personal.xls


Gord
 
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!
 
Long way around but glad you're sorted


Gord

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!
Click to expand...
 
Back
Top