View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Macro warning pops up at file open

Turning the warning off is simply enough achieved by setting macro security
to low. Click Tools - Options - Security tab - macro security and set it to
low. The warning now won't appear.

Whether you should do it is another matter. Viruses transimitted via
workbooks are now thankfully rare with virus writers preferring other means
of being a pest but they are still about and my own view; for what it is
worth, is to leave macro security alone.

Mike

"Texas Tonie" wrote:

I added a macro to a couple of sheets in my workbook. Now eachtime I open the
workbook, it asks me about the Macro's.

Is there a way that I can turn off this pop-up warning, and is this
something that you want to do?

It mentions a signature on the Macro, but the macro is not signed, with
certificate name set as [no certificate].