hi
put this before the save perfered at the start of the macro.
application.displayalerts = false
then at the end of the macro, before end sub
application.displayalerts = true.
i have not tried this in 07 but it works quite well in 03.
regards
FSt1
"bmatuk" wrote:
I would like to automate the running of macros in a number of Excel workbooks
(.xlsm files) with a VB.Net application.
The problem is that when the macro completes, and the code tries to save the
.xlsm file, I get the following privacy warning:
"
Privacy warning: This document contains macros, ActiveX controls, XML
expansion pack information, or Web components. These may include personal
information that cannot be removed by the Document Inspector.
"
Is there a way to suppress the warning, or to "OK" it implicitly? I checked
the Trust Center options, but couldn't find a setting that would disable this
warning.
Thanks!