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
--
cinnie

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

"cinnie" wrote:

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
--
cinnie

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/ex...495571033.aspx

2007
http://office.microsoft.com/en-us/ex...317811033.aspx


--
jb


"cinnie" wrote:

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
--
cinnie