Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Warning in File w/o Macros?
Hello -
I have the security level of Excel set to Medium so that it asks me about enabling macros when I open a file that contains macros. The strange thing is that I did a "Save as..." and then used the following commands to strip out all the code: Set VBCodeModule = ActiveWorkbook.VBProject.VBComponents("Sheet2").Co deModule With VBCodeModule lStartLine = 1 lHowManyLines = .CountOfLines .DeleteLines lStartLine, lHowManyLines End With So there shouldn't be any more macro code in that spreadsheet but every time I open the file Excel asks me about whether I want to enable macros? How can I turn that off? Thanks, Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro warning despite no macros in document | Excel Discussion (Misc queries) | |||
Macro warning even though macros have been removed. | Excel Discussion (Misc queries) | |||
macro warning - but no macros | Excel Discussion (Misc queries) | |||
Macro warning when no macros | Excel Programming | |||
Macro warning when no macros in workbook | Excel Programming |