| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can't Delete Macro
I have one file that prompts me to Enable Macros or Disable Macros every time
I open it. However, when I get the file open and go to Tools - Macro - Macros, there are no macros listed under "This Workbook" or "All Open Workbooks"...why is Excel giving me this prompt when I open the file and how can I get rid of it without getting rid of the prompt when there is actually a macro? Thanks, Denise |
|
#2
|
|||
|
|||
|
there is probably a module which could have a macro.
goto <tools<macro<View visual basic and see if there is a module. if so, delete the module "denise" wrote: I have one file that prompts me to Enable Macros or Disable Macros every time I open it. However, when I get the file open and go to Tools - Macro - Macros, there are no macros listed under "This Workbook" or "All Open Workbooks"...why is Excel giving me this prompt when I open the file and how can I get rid of it without getting rid of the prompt when there is actually a macro? Thanks, Denise |
|
#3
|
|||
|
|||
|
That was it, thanks a lot!
"bj" wrote: there is probably a module which could have a macro. goto <tools<macro<View visual basic and see if there is a module. if so, delete the module "denise" wrote: I have one file that prompts me to Enable Macros or Disable Macros every time I open it. However, when I get the file open and go to Tools - Macro - Macros, there are no macros listed under "This Workbook" or "All Open Workbooks"...why is Excel giving me this prompt when I open the file and how can I get rid of it without getting rid of the prompt when there is actually a macro? Thanks, Denise |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
| Macro to delete data in 'green' cells only | Excel Worksheet Functions | |||
| Cannot delete a 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 | |||
Linear Mode
