Macro warning pops up at file open

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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].
 
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
 
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 said:
I added amacroto a couple of sheets in my workbook. Now eachtime I open the
workbook, it asks me about theMacro's.
Click to expand...
Is there a way that I can turn off this pop-upwarning, and is this
something that you want to do?
Click to expand...
It mentions a signature on theMacro, but themacrois not signed, with
certificate name set as [no certificate].- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

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?
 
Back
Top