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