Is there a code that will allow me to automatically "Enable Macros" or "Disable Macros" when the "Microsoft Excel Security Notice" pops up in Excel? My code currently is setup to open and close for copying a pasting from one workbook to another so this warning pops up about 20 time while the code is running and it would be nice to enable to macros without having to click the button every time.
Thank you
if you are opening and closing workbooks in code the message should not appear.
Josie
if at first you don't succeed try doing it the way your wife told you to
I may have said that wrong since im not that experienced with excel, but the code it setup in a way to where the notice pops up after every process in the code.
Can you post the code you are using? My crystal ball is a bit overcast today...
There is not, however you can adjust your Trust Center security setting. Enable macros or use the Trusted Location setting.
~Toby
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks