ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I enable macros in an encrypted document? (https://www.excelbanter.com/excel-discussion-misc-queries/192012-how-do-i-enable-macros-encrypted-document.html)

HC

How do I enable macros in an encrypted document?
 
I have created a macro in a document protected by a password (encrypted).
Unfortunately, Excel does not enable me to run the macro .
"this file contain encrypted macro that have been disabled because there is
no antivirus software installed that can scan them . To run the macro, remove
the encryption or permission restriction on the file"

I am running Sophos
I have tried to create a trusted location but it did not make any difference.

Any idea please?

Thank you.

H.

Jim Rech

How do I enable macros in an encrypted document?
 
The only workaround for this Excel 2007 problem is a registry entry:

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

--
Jim
"HC" wrote in message
...
|I have created a macro in a document protected by a password (encrypted).
| Unfortunately, Excel does not enable me to run the macro .
| "this file contain encrypted macro that have been disabled because there
is
| no antivirus software installed that can scan them . To run the macro,
remove
| the encryption or permission restriction on the file"
|
| I am running Sophos
| I have tried to create a trusted location but it did not make any
difference.
|
| Any idea please?
|
| Thank you.
|
| H.




All times are GMT +1. The time now is 06:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com