Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Warnings on Save
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable or hide Cancel button on Save dialog box | Excel Programming | |||
Warnings | Excel Discussion (Misc queries) | |||
VB Help (Excel Warnings) | Excel Programming | |||
hide save as | Excel Programming | |||
Need Help - save sheet then hide when.... | Excel Programming |