Macro warning pops up at file open

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

Guest

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
 
J

jmagestro

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top