By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,055 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

Programmatically Turn Off Excel Macro Warning

LacrosseB0ss
100+
P: 113
Quick question: is there a way to programmatically turn off the warning message for macros in Excel? (Macros can be harmful ... enable/disable)

The reason for the question is on our intranet page we have a link to an HR document a lot of people use. However, this document runs macros. We would like to, if possible, have the message NOT be displayed. It has been confusing some users as they don't know it's an Excel doc. Nor do they really know how to answer the question.

Thanks everyone:
- LB

PS: Not sure if this is the correct place for this post. Can a mod move it if it isn't. Thanks!
Jun 13 '07 #1
Share this Question
Share on Google+
3 Replies


RedSon
Expert 5K+
P: 5,000
Quick question: is there a way to programmatically turn off the warning message for macros in Excel? (Macros can be harmful ... enable/disable)

The reason for the question is on our intranet page we have a link to an HR document a lot of people use. However, this document runs macros. We would like to, if possible, have the message NOT be displayed. It has been confusing some users as they don't know it's an Excel doc. Nor do they really know how to answer the question.

Thanks everyone:
- LB

PS: Not sure if this is the correct place for this post. Can a mod move it if it isn't. Thanks!
Excel warns about macros to make the user aware of certain macro viruses that can be transmitted through excel documents. I think that you can sign your excel templates using your companies certificate and then it wont complain about that since it will then be trusted. You might want to read through Excel's help files to see what they say.
Jun 13 '07 #2

LacrosseB0ss
100+
P: 113
We know WHY Excel does it but we also know that we are a trusted source. This is more a "nice to have" thing than a requirement. Thanks for the reply.
Jun 13 '07 #3

RedSon
Expert 5K+
P: 5,000
We know WHY Excel does it but we also know that we are a trusted source. This is more a "nice to have" thing than a requirement. Thanks for the reply.
Can you sign the documents so that the other computers know that its from a trusted source?
Jun 13 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.