Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I delete a macro in excel?
I had created a button in excel, which created a macro. I decided not to
keep the button so I deleted it, assuming that the macro would be deleted as well. I saved the file and closed it. However, on reopening it, I received an error message because my security level is set so that macros will not run. I do not want to change the security level, so I went to Tools--Macros--Macros (or Alt-F8) to delete the macro. The macro is there but it will not let me delete nor edit it. These options are not highlighted for me to choose? How can I get rid of this macro? The button the macro was created for is already gone, and I cannot redo the spreadsheet. Any advice? Thanks, Katzy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I delete a macro in excel?
Just select the macro and delete. If it is in a code module *not a sheet or
ThisWorkbook), remove the module as well (FileRemove Module) -- HTH Bob Phillips "katzy" wrote in message ... I had created a button in excel, which created a macro. I decided not to keep the button so I deleted it, assuming that the macro would be deleted as well. I saved the file and closed it. However, on reopening it, I received an error message because my security level is set so that macros will not run. I do not want to change the security level, so I went to Tools--Macros--Macros (or Alt-F8) to delete the macro. The macro is there but it will not let me delete nor edit it. These options are not highlighted for me to choose? How can I get rid of this macro? The button the macro was created for is already gone, and I cannot redo the spreadsheet. Any advice? Thanks, Katzy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Delete VB Macro | Excel Worksheet Functions | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
I need a macro that will delete every other row in excel. | Excel Programming | |||
Delete records using excel Macro | Excel Programming | |||
Delete records using excel Macro | Excel Programming |