Stopping warning message

[cinnie]

greetings gurus

I have a workbook that I open several times a day. On opening, I always get
a warning message that the file "contains macros.....". I'm given three
choices - Disable Macros, Enable Macros, or More Info. How can I prevent
this message from showing. I always want to Enable Macros.

TQ

 

[Mike H]

Hi,

It's not something I would recommend but if you set your macro security
level to 'Low' then you won't get the message

Tools|Macro|Security - select 'LOW'

There is no way to automatically enable macros, if there was the virus
writers could have a field day.

Mike

 

[john]

If you have access to the VBA project you could create a self signed
certificate (which will be valid only on the PC the certificate was created)
& install in the VBA project of your workbook.

This once accepted, should prevent the security warning appearing.

Have a read of this article & see if helps:

2003
http://office.microsoft.com/en-us/excel/HP052495571033.aspx

2007
http://office.microsoft.com/en-us/excel/HA012317811033.aspx