Can't Run Macros; Blocked By Security

R

RandomStu

My hard drive crashed, and I had to re-install Office 2007. I open
Excel, and try to open .xlsm workbook I'd created previously. when it
opens, I have under the ribbon:

Security Warning Macros have been disabled.

So I click the Options button, and I get:

"Security Alert This file contains encrypted macros that have been
disabled because there is no antivirus software installed that can
scan them. To run these macros, remove the encryption or permission
restrictions on the file."

The only option I'm offered in this popup box is "Help protect me from
unkown content (recommended)." I no longer have the option of allowing
macros to run, as I did before this hard drive crash.

I do in fact have antivirus software. My ISP is Comcast, and they
include in their subscription cost a free Norton Security Suite, which
I've downloaded from the Comcast site and have running.

So... what do I need to do so that I can run my macros like before??

Many thanks for any help.

Stuart Resnick
http://www.allexperts.com/ep/1059-73...rt-Resnick.htm
 
G

Gary''s Student

When you re-installed Office it probably "forgot" or "became unaware of" the
Norton setting.

1. Close all Office applications.
2. Open Norton.
3. First disable the option to check office files.
4. Then re-enable the option to check office files.
5. then open Excel and see if the fix worked.
 
R

RandomStu

Thanks for your response below. Could you kindly tell me what exactly you
mean by:
3. First disable the option to check office files.
4. Then re-enable the option to check office files.

Stuart Resnick
(e-mail address removed)
 
S

Stuart Resnick

Thank you. On my Norton Suite, I cannot find how to:
3. First disable the option to check office files.
4. Then re-enable the option to check office files.

Please let me know exactly what this means.

Stuart Resnick
(e-mail address removed)
 

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