Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing a macro from a workbook
I have a workbook that I used a few macros on, and possible created one in
(but deleted) and now whenever anyone opens it they get the enable/disable macro warning. I've looked in all places that I know to find a macro to delete, but there is nothing. How to I clear what ever is prompting the warning thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing a macro from a workbook
Hi Roger
You need to also delete any/all standard modules that you have in the workbook (whether or not they actually conatin any code) to make sure you don't get that annoying macro warning (I assume you've cleared the Thisworkbook/Sheets modules). Hope this helps! Richard Roger wrote: I have a workbook that I used a few macros on, and possible created one in (but deleted) and now whenever anyone opens it they get the enable/disable macro warning. I've looked in all places that I know to find a macro to delete, but there is nothing. How to I clear what ever is prompting the warning thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing a macro from a workbook
Roger
You have to also delete the module the macro(s) were stored in. With your workbook open hit Alt + F11 to open VBEditor then CTRL + r to open Project Explorer. Expand your workbook/project and right-click on Module1 and "Remove" Click NO when asked if you want to Export the module. Gord Dibben MS Excel MVP On Fri, 22 Dec 2006 12:13:01 -0800, Roger wrote: I have a workbook that I used a few macros on, and possible created one in (but deleted) and now whenever anyone opens it they get the enable/disable macro warning. I've looked in all places that I know to find a macro to delete, but there is nothing. How to I clear what ever is prompting the warning thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
How can I get a validation to run in a macro on a shared workbook? | Excel Discussion (Misc queries) | |||
Issuing macro in workbook from separate workbook | Excel Discussion (Misc queries) | |||
macro to browse for workbook, pick up data and looping | Excel Worksheet Functions | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |