Force a User to Enable Macros in Excel - Advanced Version

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.

Enjoy guys!

#excel #tutorial #howto

Hello. Thanks for this great video.

Is it possible to make a key to activate an excel file with an expiry date? If there's any tutorial kindly share with me the link

[wayneedmondson]

Nice video. Like your ideas and techniques. Thumbs up!

[jeffreymess]

If the user closes the file and selects "Cancel" insead of saving and closing the file, it leaves them with the splash page and no other sheets. Is there a way to bring back all of the worksheets if the user selects "Cancel" when they are prompted to save?

[golfinfool]

Just curious but I have several worksheets in the workbook but would only want to unhide one of them. How would I do that?

[warezon]

Very nice video, just one little bug when trying to cancel closing, the document will stuck on the welcome screen.

[krmynk]

Another issue, the code also unlocks hidden sheets. This is something we do not want. Any solution?

[richarddickson]

Hi I am new with excel. I would like to use your model but I have a small problem, when I use your model always paper the name of Karen can you help me please... greetings from Colombia

[mokhos]

Your videos is very nice & useful. I am watched your "Automatically Timestamp Data Entries in Excel" . Now I want to know 'how to automatically Timestamp Data Entries in protected sheet?

[chemrn]

I was trying to use this for one of my workbooks but the code has a bug. I downloaded and opened the example file and it works beautifully when you first open it, but if you save the workbook and reopen it, it no longer opens on the splash screen. Why does it only work until I save it??