Removing Macro Icon and Menu List Iten

  • Thread starter Thread starter Gordon Wilmot
  • Start date Start date
G

Gordon Wilmot

Hi,
I am using Windows XP and Office 2000.
I have just completed an exercise in Excel requiring to
put an icon on the tool bar and an item in the Tools menu
list to operate a macro.

I now find I cannot get rid of the icon or the menu item,
and they appear in all my workbooks inspite of
stipulating that the macro was only to be used in the
workbook in which it was generated.

I have tried uninstalling Office, but on re-installing
Office, I find they are still there.

Hope you can help
Gordon Wilmot
 
In the workbook that creates the new menu item place this code in the
workbook_beforeclose event:

Application.CommandBars(1).Controls("Tools").Controls(your new menu
name).Delete
Before the workbook closes it will delete this new menu item so it won't be
available until the workbook that created it is re-opened.

HTH
 
Hi Gordon Wilmot,

When customizing menu, you can select the tool bar and reset it. Or you can
look for *.xlb file on Windows folder and delete it.

HTH
 
Back
Top