Cannot enable macros

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?

excel

Macros and VBA

FabioCavalieri
Nov 30, 2021
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. 😠

6 Replies

JKPieterse
Silver Contributor
Nov 30, 2021
What is your macro setting in File, Options, Trust center, Trust center settings, macro tab?
- FabioCavalieri
  Copper Contributor
  Nov 30, 2021
  JKPieterse enable all macro and I have the flag on trust access on vba project object model
  - JKPieterse
    Silver Contributor
    Nov 30, 2021
    FabioCavalieri Any chance the files are blocked? https://jkp-ads.com/Articles/Excel-Add-ins-fail-to-load.asp

Forum Discussion

Cannot enable macros

6 Replies

Resources