SOLVED

Cannot enable macros

%3CLINGO-SUB%20id%3D%22lingo-sub-3017563%22%20slang%3D%22en-US%22%3ECannot%20enable%20macros%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3017563%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3Eafter%20setting%20up%20a%20new%20PC%2C%20upgrade%20to%20Windows11%2C%20I've%20installed%20Office%20Home%26amp%3BBusiness%202019%2C%20did%20all%20the%20update.%3C%2FP%3E%3CP%3ENow%2C%20when%20I%20try%20to%20open%20a%20file%20.xlsm%20with%20macros%20inside%2C%20the%20button%20%22enable%20all%22%20(file-%26gt%3Binformation-%26gt%3Benable%20content)%20remains%20gray%2C%20it%20cannot%20be%20clicked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20can%20help%20me%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3017563%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3018053%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20enable%20macros%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3018053%22%20slang%3D%22en-US%22%3EWhat%20is%20your%20macro%20setting%20in%20File%2C%20Options%2C%20Trust%20center%2C%20Trust%20center%20settings%2C%20macro%20tab%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3018150%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20enable%20macros%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3018150%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3Benable%20all%20macro%20and%20I%20have%20the%20flag%20on%20trust%20access%20on%20vba%20project%20object%20model%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello everyone,

after setting up a new PC, upgrade to Windows11, I've installed Office Home&Business 2019, did all the update.

Now, when I try to open a file .xlsm with macros inside, the button "enable all" (file->information->enable content) remains gray, it cannot be clicked.

 

Anyone can help me?

5 Replies
What is your macro setting in File, Options, Trust center, Trust center settings, macro tab?

@Jan Karel Pieterse enable all macro and I have the flag on trust access on vba project object model

I tried but no, my files are not blocked and on other PCs everything works fine
best response confirmed by FabioCavalieri (New Contributor)
Solution
I've found a solution. It seems excel not recognise as trusted location my C:\ and my net shares, so adding those everything works again.