Macro virus warning when I open an Excel workbook

[uuppal]

Please let me know as how to disable macro virus warning when I open an Excel workbook that has safe macros.

regards,
Uppal

 

[KMKfan]

Tools>Macro>Security...set to Low.

I think this is an Excel setting (not just the current workbook) so it will automatically allow macros on all workbooks. Don't know of any other way, though.

 

[Smitty]

Welcome to the Board!

Low is the option that we use, but note that there are inherent risks of allowing malicious code onto your PC if you do not have a virus protection program installed.

If it's your code, you can look into creating a Digital Certificate

Hope that helps,

Smitty

 

[uuppal]

Thank you for the feedback.
Uppal