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.