I'm working on a work book and when I go to tools----Macro---Macros there
are a list of macros that are supposedly in my work book but in reality they
are not. Is there any way to delete these out? (The delete button is not
enabled so I can not use it)

If not in your workbook the macros are from another workbook that is open.

Most likely your hidden Personal.xls. These macros you want to keep. They
are for use on all open workbooks.

Check WindowUnhide to see what else is open.

If it is your Personal.xls file and it annoys you, Close Excel then move
Personal.xls out of your XLSTART folder.

Hit ALT + F11 to go to the Visual Basic Editor.

Hit CTRL + r to open the Project Explorer

See what workbooks(*.XLS only) are open and check each of them for modules.

It won't be an Add-in because Add-in macros are not shown in
ToolsMacroMacros.


Gord Dibben Excel MVP


On Tue, 22 Nov 2005 12:52:07 -0800, "mydogpeanut"
wrote:

I'm working on a work book and when I go to tools----Macro---Macros there
are a list of macros that are supposedly in my work book but in reality they
are not. Is there any way to delete these out? (The delete button is not
enabled so I can not use it)