I can't find in the macro you presented where it determines when the user enables the macros. Might be obvious but I can't see it. Thanks!
I can't find in the macro you presented where it determines when the user enables the macros. Might be obvious but I can't see it. Thanks!
If you would publish the code you are using, or perhpaps the circumstances in which you use it, an answer to your question shouldn't be too difficult. As things are, there is no code to enable macros. Microsoft is very concerned that only the user, and only by his own determined action, should be able to enable macros. You can do that in the system's Security Settings.
Howqever, since you expect there to be be code that enables the running of macros, you might look for Application.EnableEvents = True (or False) which turns on and off event procedures. That are macros which are triggered by "events", such as when youi click or change a cell or change sheets or simply open a workbook.