View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
bmatuk bmatuk is offline
external usenet poster
 
Posts: 1
Default Hide Warnings on Save

Thank you very much for your quick and accurate response!
Yes, it works wonderfully in Excel 2007.

Thanks for your help!!!

"FSt1" wrote:

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!