Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Macros from a Worksheet
We have a company standard of adding macros only to a
startup PERSONAL worksheet, and leaving them out of our work product that goes to our client. Yesterday, I forgot and created one. Although I deleted it, I still get the Disable/Enable Macros dialog on opening it. Does anyone know how I can eliminate this message? TIA Kevin Sprinkel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Macros from a Worksheet
Kevin,
You need to remove the module in which the macro resided. An empty module will cause the macro warning to appear. "Kevin Sprinkel" wrote in message ... We have a company standard of adding macros only to a startup PERSONAL worksheet, and leaving them out of our work product that goes to our client. Yesterday, I forgot and created one. Although I deleted it, I still get the Disable/Enable Macros dialog on opening it. Does anyone know how I can eliminate this message? TIA Kevin Sprinkel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Macros from a Worksheet
There are instructions here for removing the module that was created
when you recorded the macro: http://www.contextures.com/xlfaqMac.html#NoMacros Kevin Sprinkel wrote: We have a company standard of adding macros only to a startup PERSONAL worksheet, and leaving them out of our work product that goes to our client. Yesterday, I forgot and created one. Although I deleted it, I still get the Disable/Enable Macros dialog on opening it. Does anyone know how I can eliminate this message? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Many Thanks to Chip, Debra, and Rob
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Macros? | Excel Discussion (Misc queries) | |||
deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
Deleting Macros | Excel Discussion (Misc queries) | |||
Deleting Macros | Excel Worksheet Functions | |||
Deleting Macros | Excel Programming |