| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| delete row contains specific word in an macro | Excel Discussion (Misc queries) | |||
| How to delete a macro that has been assigned to run when workshee. | Excel Worksheet Functions | |||
| Macro to delete a macro | Excel Worksheet Functions | |||
| How to delete a Macro from within another Macro | Excel Worksheet Functions | |||
Linear Mode
