Force a User to Enable Macros in Excel - Advanced Version

Add to Favorites
Author: | Edits: don

This tutorial shows you how to force a user to enable macros before they can use the workbook in Excel.

To do this, we must actually use a series of macros and these macros and VBA code are included for free in the links above. You can download the code and try it out and also look at it while you view this tutorial in order to follow along.

In the tutorial, I'll show you how everything works - I'll show you how the "forcing the user to enable macros" feature works and then, if you want, you can keep watching as I go over every line in the macro and try to explain what everything does in as simple terms as is possible; bear in mind, some aspects of this series of macros can get confusing :P.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 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

Tutorial Details
Downloadable Files: Excel File
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