Workbook Security questions

[claytonhp]

We have a workbook that pulls information in from a database and also pulls in information from another spreadsheet. We also run a macro to change some values in the workbook.

There are three popup messages when the spreadsheet is opened that I am interested in avoiding that they pop-up after the workbook is sent to a customer.

#1) Security Warning - This sheet contains macros. Disable, Enable, More are the popup options. Short of purchasing a certificate, is there another way of not having this pop up come up?

#2) Workbook contain Links - Update, Don't Update, Help are the command button choices. This doesn't need to update after the information is pulled in and the macro is ran.

#3) Query Refresh - Enable AutoRefresh, Disable AutoRefresh. This doesn't need to update after the information is pulled in and the macro is ran.

Here is my question - Is there a way to turn these popup messages off or systematically disconnect the query Refresh and Workbook Links and Macro Security warning?

 

[Smitty]

Welcome to the Board!

For the first you need to either set security to Low (which is not recommended unless you have a virus scan program installed - it's what I do), or use a digital signature. See Self-Cert in the Excel helpfile.

For the second you can goto Tools-->Options-->Edit-->Uncheck "Ask to update automatic links". You also have options in the Edit-->Links dialog.

For the Query Refresh you can also set those settnigs in the query options.

Finally, in your code you can use: Application.DisplayAlerts = False at the beginning, which will suppress messages. Just make sure to set it back to true at the end of your code.

Hope that helps,

 

[Greg Truby]

Regarding question #1...

http://www.mrexcel.com/forum/showthread.php?t=110793

 

[claytonhp]

For #2 & 3 - Thank you I will try that!

For #1 - I will try the self cert and take it from there.

Thank you