Cannot delete a macro

G

Guest

I have inherited an old workbook that has a macro that no longer works. I
believe that it was intended to open other linked workbooks. I want to
delete the macro, but in the macro dialog window, I am unable to. The delete
button is unavailable.

If I try to run it, edit it, step into it, I get the message "Reference is
not valid." How can I delete this macro?
 
G

Guest

View the code of the book. Find the macro and select the code. Delete the
appropriate code.
 
G

Guest

I am unfamiliar with how to view the code and then finding the macro. Can
you provide more details?
 

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

delete an invalid macro name 1
Delete a macro using a macro 4
"Reference not valid" error when I try to edit the macro in excel 1
macro to delete another macro 1
How do I delete a macro in Excel 2003? Button is greyed out. 3
How do I delete a missing reference to a Macro 3
@Sum Conditional Values within a Macro 1
Delete macro that is not in a module 5

Top