ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro Prompt (https://www.excelbanter.com/excel-programming/271227-macro-prompt.html)

Andrew Park

Macro Prompt
 
Whenever I start Excel, I get a prompt asking if I want to
disable or enable macros. I was wondering if there's a
way to get rid of it because I have a lot of workbooks
that have macros. Thanks.

Trevor Shuttleworth

Macro Prompt
 
Andrew

you can switch it off (not recommended), digitally sign your code or put up
with it. It's for your protection.

Regards

Trevor


"Andrew Park" wrote in message
...
Whenever I start Excel, I get a prompt asking if I want to
disable or enable macros. I was wondering if there's a
way to get rid of it because I have a lot of workbooks
that have macros. Thanks.




John Wilson

Macro Prompt
 
Andrew,

Tools/Macro/Security
Set security level to Low.

Having done that, be wary of files from untrusted sources
that may contain malicious code.

John

Andrew Park wrote:

Whenever I start Excel, I get a prompt asking if I want to
disable or enable macros. I was wondering if there's a
way to get rid of it because I have a lot of workbooks
that have macros. Thanks.




All times are GMT +1. The time now is 12:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com