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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
hiput this before the save perfered at the start of themacro.application.
where are the macros so that I can modify them?
On Friday, December 12, 2008 5:44 PM bmatu 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! On Friday, December 12, 2008 8:06 PM FSt 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: On Saturday, December 13, 2008 12:24 PM bmatu wrote: Thank you very much for your quick and accurate response! Yes, it works wonderfully in Excel 2007. Thanks for your help!!! "FSt1" wrote: Submitted via EggHeadCafe Office Open XML File Formats - Word 2007 http://www.eggheadcafe.com/tutorials...word-2007.aspx |
Reply |
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 |