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

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

Hello -

Unfortunately the code was in Sheet2 of that spreadsheet and I cannot
delete that.

Thanks,
Joe

go to each such module and do Ctrl+A, then hit delete

Then save the file.

--
Regards,
Tom Ogilvy


"Joe HM" wrote in message
ups.com...
Hello -

Unfortunately the code was in Sheet2 of that spreadsheet and I cannot
delete that.

Thanks,
Joe

Hello -

That code works great but for some reason I still get the message. I
did some debugging and it seems that as soon as I do a
ActiveWorkbook.SaveAs Filename:="Dummy.xls", FileFormat:=xlNormal
after stripping out all the code it does something to the workbook to
make it think that it contains macros.

Any idea?

Thanks,
Joe