Forum Discussion
Excel Macrons
Excel Options --> Trust Center --> Trusted Documents...
Select point 2 "Disable all macros with notification".
If you now open a workbook, the macros are first deactivated when you open them and you have to activate them in a targeted manner.
This way you can memorize the problematic macro and see where the error might be.
On the other hand, it can also be due to the storage location, or to a digital signature of the macro (if available).
However, without the file, it is hardly possible to guess what the source of the problem is...unless someone has already had such a problem.
Maybe delete all sensitive data from the file and then make it available to research the vba structure of the workbook.
Knowledge of the digital environment helps immensely to identify the source of error.
Digital environment, such as workbook extension (.xlsx, xlsm, etc.), Excel version, operating system, storage medium (hard drive, OneDrive, Sharepoint, etc.).
Thank you for your understanding and patience
I know I don't know anything (Socrates)