Enabling macros by using VBA code

Re: Enabling macros by using VBA code

Quote from ssmilu;797340

Is it possible to run a vba code to enable the macros and before exit the worksheet disable the macros.

Hello,

The short answer in No ... since this is considered as a crucial security issue by Microsoft ...

You do need to set your Excel Options accordingly ...

Hope this will help

Re: Enabling macros by using VBA code

May be using a registry file to enable macros will be useful for you

Re: Enabling macros by using VBA code

Note that while you can set your computer to automatically enable macros, you cannot create a workbook that will automatically have macros enabled when run on other's machines.