Hello -
Sorry to bug you guys again but I have been using code to strip out any
possible
VB code and module from my file. Then I do a SaveAs and close
it.
ActiveWorkbook.SaveAs Filename:="Dummy.xls", FileFormat:=xlNormal
ActiveWorkbook.Close
When I open the file Excel will still prompt me with the macro warning.
So I played with it and added the following lines after the above code
.... essentially re-opening the file and saving it again.
Set lLogFile = Workbooks.Open("Dummy.xls")
lLogFile.Save
lLogFile.Close
For whatever reason this helped and now I don't get the warning anymore
when I open Dummy.xls.
I would rather not do it that way so maybe somebody out there has an
idea what is going on?
Thanks,
Joe