Cannot delete a macro
 

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?

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

"Jeff B" wrote:

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?

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



"Chad" wrote:

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

"Jeff B" wrote:

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?

See Debra Dalgleish's site:
http://www.contextures.com/xlfaqMac.html#NoMacros

Jeff B wrote:

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

"Chad" wrote:

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

"Jeff B" wrote:

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?


--

Dave Peterson