Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Macro that Forces the User to Enable Macros

0

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!

Answer
Discuss

Answers

0

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.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login