Spreadsheet contains macros. On startup of any spreadsheet the macros are disabled. To activate macros need to select option before proceeding. I thought to record macro to carry out this function. However the selecttion to OK a macro is disabled and removed from options after it has been selected hence cannot access to record. Code to acheive enable on startup needed. recall “autoexec” or similar macro needed with appropriate code.
Share
It can be…sort off. I can’t test any of these options at the moment, so I’m working from memory.
Option 1:
I believe that the “Disable all macros with notification” option will check each file and present a warning if the file contains a macro. I believe that the user is given the option to enable macros just for that file but it might be for just that session. At least the user wouldn’t have to go into the Trust Center every time. See here:
https://faculty.fuqua.duke.edu/~pec…
Option 2:
See this site about storing files in a Trusted Location. When a Trusted Location is used, the macro security settings in Excel are essentially ignored, thereby enabling macros for any files stored there.
https://support.office.com/en-us/ar…
Option 3:
There is also a means to Digital Sign a workbook containing macros as a workaround for this issue, but I am not familiar with the process. You might want to Google around to see if that option might work. I believe that the user has to create the workbook that they want to sign, so I don’t know if that even fits your situation.
Good luck!
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.