Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro warning even though macros have been removed. | Excel Discussion (Misc queries) | |||
macro warning - but no macros | Excel Discussion (Misc queries) | |||
Macro Warning in File w/o Macros? | Excel Programming | |||
Macro warning when no macros | Excel Programming | |||
Macro warning when no macros in workbook | Excel Programming |