Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing Macros from Workbook
For mass data populating purposes, I created a small macro to take care
of a repetitive task. I saved the file and then started using the macro. Once that was done, I deleted the macro, expecting that all traces of it would be gone. Now, when I open the file, it brings up the "this contains macros" dialog box. I've gone back in and used Visual Basic Editor and deleted Module 1. I scanned through the various sheets (within the editor) and don't see any signs of a macro. I copied each sheet (Move/copy) into a new workbook, and saved, and when opening the new one, it still shows the macro dialog box. How can I remove all traces of there ever having been a macro, so users don't get this message? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clearing a cell based on the value of another cell (INDIRECT data) without macros | About this forum | |||
clearing macros in excel when none show up | Excel Discussion (Misc queries) | |||
preventing macros from clearing the undo list | Excel Programming | |||
Worksheet clearing Macros? | Excel Discussion (Misc queries) | |||
Accessing/Clearing range in hidden workbook | Excel Programming |