Encrypted Macros

%3CLINGO-SUB%20id%3D%22lingo-sub-2036344%22%20slang%3D%22en-US%22%3EEncrypted%20Macros%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2036344%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20computers.%20Both%20installed%20with%20Office%20365%20and%20Avast%20Free%20Anti-virus.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20with%20some%20excel%20with%20macros.%20Since%20I%20don't%20want%20my%20colleagues%20to%20amend%2Fchange%20the%20code%2C%20the%20macro%20project%20is%20set%20with%20a%20password.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20when%20I%20run%20the%20file%20on%20computer%20A.%20It%20shows%20the%20yellow%20bar%20at%20the%20top%20stating%3A%26nbsp%3BSECURITY%20WARNING%20Macros%20have%20been%20disabled%20and%20after%20that%20is%20a%20button%20labelled%20as%20%22Options...%22%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20I%20click%20the%20%22Options%22%20button%2C%20it%20shows%20another%20windows%20and%20stating%20the%20following%20message%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThis%20file%20contains%20encrypted%20macros%20that%20have%20been%20disabled%20because%20there%20is%20no%20antivius%20software%20installed%20that%20can%20scan%20them.%20To%20run%20these%20macros%2C%20remove%20the%20encryption%20or%20permission%20restrictions%20on%20the%20file%3C%2FP%3E%3CP%3EFile%20Path%3A%20......%3CBR%20%2F%3EThere%20is%20only%20one%20choose%20%22Help%20protect%20me%20from%20unknown%20content%22.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20click%20okay%2C%20it%20does%20not%20further%20any%20procedure.%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20the%20same%20file%20is%20run%20on%20computer%20B%2C%20the%20yellow%20bar%20shows%20%22SERCURITY%20WARNING%20Marcos%20have%20been%20disabled.%22%20and%20then%20there%20is%20a%20button%20labelled%20with%20%22Enable%20Content%22.%20After%20clicking%20the%20%22Enable%20content%22%20button%2C%20I%20can%20run%20the%20macros%20I%20prepared.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20checked%20that%20the%20%22trust%20center%20setting%22%20on%20two%20computers%20are%20exactly%20the%20same.%20How%20can%20I%20run%20the%20macros%20in%20computer%20A%3F%20Thanks%20a%20lot.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2036344%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Contributor

I have two computers. Both installed with Office 365 and Avast Free Anti-virus. 

 

I am working with some excel with macros. Since I don't want my colleagues to amend/change the code, the macro project is set with a password. 

 

However, when I run the file on computer A. It shows the yellow bar at the top stating: SECURITY WARNING Macros have been disabled and after that is a button labelled as "Options..."

When I click the "Options" button, it shows another windows and stating the following message: 


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

File Path: ......
There is only one choose "Help protect me from unknown content". 

But click okay, it does not further any procedure.

When the same file is run on computer B, the yellow bar shows "SERCURITY WARNING Marcos have been disabled." and then there is a button labelled with "Enable Content". After clicking the "Enable content" button, I can run the macros I prepared. 

 

I checked that the "trust center setting" on two computers are exactly the same. How can I run the macros in computer A? Thanks a lot. 

 

1 Reply

@Man Fai Chan 

 

I have experienced the exact same problem and have not been able to solve it. Check also the settings on the antivirus system and both computers are identically set.

Awaiting for someone to come up with a solution