In such cases, the macros are enabled permanently to save time. If a file received from a trusted source contains a macro or VBA content, the macros need to be enabled for using the file.
How to Enable all Macro Files in Excel Permanently?
These controls are necessary for the object of macros. The ActiveX controls are activated to enable macros properly.
Click “Ok” to apply the selected macro settings.
Click it into Excel Options Window.įigure 2: Excel Options button in Excel 2007 Ribbon