Macro warning pops up at file open
 

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].

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].

Macro warning pops up at file open
 

On Apr 12, 2:28 pm, Mike wrote:
Turning thewarningoff is simply enough achieved by settingmacrosecurity
to low. Click Tools - Options - Security tab -macrosecurity and set it to
low. Thewarningnow 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 leavemacrosecurity alone.

Mike



"Texas Tonie" wrote:
I added amacroto a couple of sheets in my workbook. Now eachtime I open the
workbook, it asks me about theMacro's.

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

It mentions a signature on theMacro, but themacrois not signed, with
certificate name set as [no certificate].- Hide quoted text -

- Show quoted text -

I have user having this problem, but it also happens when opening
Access files, and accessing any contact in Outlook that has something
entered in the address field.

Any thoughts?