View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Stopping warning message

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