Hi Palmetto & JohnJohns,
Here's what I've done:
I changed my settings per your instructions
In a new file, I created a couple simplistic macros & save the file with "Excel Enable-Macros Workbook"
Closed & Excel & reopened
Now, I do get the security option message & selected enable macros
These instructions seem to work great for new files created.
However, I have a bunch of files that were created some time a go & have, what I call, "pre-define" macros. Meaning, I created the macros to primarily sort a bunch of rows or columns.
Even after I close Excel & reopen it, I do not get the Security Option message.
I even re-created my sort functions by creating another macro, Save the file.
I'm trying to avoid having to re-create all my macros in my existing files.
I attached a file for example.
In this file, I have to command buttons.
Here, you should be able to see my macro settings & advise what the correct settings are.
I also added my primary directory as my trusted locations.
Once, I am able to "enable" macros (permanently), I expect my macro issue will be resolved with my existing files that have macros in them.
Thanks again for the assistance.
Bookmarks