deleting macros that are not really in my workbook?

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

Guest

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 Window>Unhide 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
Tools>Macro>Macros.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing disabled Macro 6
Macro warning - how to delete macro 3
Collapsing all groups 0
Removing Macros 4
Run code from another workbook 7
Deleting worksheets in a macro 2
Excel Macro for deleting Rows containing dates greater than "today" 0
Disabling saving 4

Back
Top