Thread
:
Macro Warning in File w/o Macros?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Macro Warning in File w/o Macros?
delete the module
--
Don Guillett
SalesAid Software
"Joe HM" wrote in message
ups.com...
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
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]