I have a file that I have saved as a .xlsm file in 2007 that has several
macros. When I open the file I get the following message.
"This file contains encrypted macros that have been disable because there is
no antivirus software instaled that can scan them. To run these macros,
remove the encryption or permission restrictions on the file."

How do I remove encryption? Why can I not run macros in a macro enabled
workbook? My excel settings enable macros...

Thanks for your help in advance

This may help:

http://www.rondebruin.nl/password2007.htm

--
Jim
"John" <(E-Mail Removed)> wrote in message
news001DD6D-2710-47AC-BF51-(E-Mail Removed)...
|I have a file that I have saved as a .xlsm file in 2007 that has several
| macros. When I open the file I get the following message.
| "This file contains encrypted macros that have been disable because there
is
| no antivirus software instaled that can scan them. To run these macros,
| remove the encryption or permission restrictions on the file."
|
| How do I remove encryption? Why can I not run macros in a macro enabled
| workbook? My excel settings enable macros...
|
| Thanks for your help in advance

is it me or does that seem funny I don't have an option to enable macros with
a password protected WB! anyway, thanks for the help

"Jim Rech" wrote:

> This may help:
>
> http://www.rondebruin.nl/password2007.htm
>
> --
> Jim
> "John" <(E-Mail Removed)> wrote in message
> news001DD6D-2710-47AC-BF51-(E-Mail Removed)...
> |I have a file that I have saved as a .xlsm file in 2007 that has several
> | macros. When I open the file I get the following message.
> | "This file contains encrypted macros that have been disable because there
> is
> | no antivirus software instaled that can scan them. To run these macros,
> | remove the encryption or permission restrictions on the file."
> |
> | How do I remove encryption? Why can I not run macros in a macro enabled
> | workbook? My excel settings enable macros...
> |
> | Thanks for your help in advance
>
>
>

I'm sure the lawyers were involved in this design.

--
Jim
"John" <(E-Mail Removed)> wrote in message
news:2D0E3B60-5CC1-466A-86E0-(E-Mail Removed)...
| is it me or does that seem funny I don't have an option to enable macros
with
| a password protected WB! anyway, thanks for the help
|
| "Jim Rech" wrote:
|
| > This may help:
| >
| > http://www.rondebruin.nl/password2007.htm
| >
| > --
| > Jim
| > "John" <(E-Mail Removed)> wrote in message
| > news001DD6D-2710-47AC-BF51-(E-Mail Removed)...
| > |I have a file that I have saved as a .xlsm file in 2007 that has
several
| > | macros. When I open the file I get the following message.
| > | "This file contains encrypted macros that have been disable because
there
| > is
| > | no antivirus software instaled that can scan them. To run these
macros,
| > | remove the encryption or permission restrictions on the file."
| > |
| > | How do I remove encryption? Why can I not run macros in a macro
enabled
| > | workbook? My excel settings enable macros...
| > |
| > | Thanks for your help in advance
| >
| >
| >

I my case, I do have current and active antivirus software running. But the
issue is the same as described.

The reg edit solution provided does solve this issue for computer still
using XP and Older versions of Antivirus ( Symantec 10.5 Client Security)
since upgrading the corporate Antivirus solution is not an option in the
short term.

Running the same Wookbook on a newer computer (Vista w/Vista compatible
Symantec Antivirus) this is not an issue.

"Jim Rech" wrote:

> I'm sure the lawyers were involved in this design.
>
> --
> Jim
> "John" <(E-Mail Removed)> wrote in message
> news:2D0E3B60-5CC1-466A-86E0-(E-Mail Removed)...
> | is it me or does that seem funny I don't have an option to enable macros
> with
> | a password protected WB! anyway, thanks for the help
> |
> | "Jim Rech" wrote:
> |
> | > This may help:
> | >
> | > http://www.rondebruin.nl/password2007.htm
> | >
> | > --
> | > Jim
> | > "John" <(E-Mail Removed)> wrote in message
> | > news001DD6D-2710-47AC-BF51-(E-Mail Removed)...
> | > |I have a file that I have saved as a .xlsm file in 2007 that has
> several
> | > | macros. When I open the file I get the following message.
> | > | "This file contains encrypted macros that have been disable because
> there
> | > is
> | > | no antivirus software instaled that can scan them. To run these
> macros,
> | > | remove the encryption or permission restrictions on the file."
> | > |
> | > | How do I remove encryption? Why can I not run macros in a macro
> enabled
> | > | workbook? My excel settings enable macros...
> | > |
> | > | Thanks for your help in advance
> | >
> | >
> | >
>
>
>