Force a User to Enable Macros in Excel - Advanced Version

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

[@TeachExcel]

You could make all sorts of mechanisms to allow for this, but remember that Excel is NOT safe and so it can easily be opened if a user wants to open and makes a 5 minute DuckDuckGo.com search. I do not have a tutorial on how to make a key for it, but you could easily make it password activated and create your own custom key that you store within the macro, this would work just like a regular password though, but it would be the easiest thing to implement. If you would like more guidance, please ask in our forum as I can't check most of the comments that I get here. www.teachexcel.com/talk/microsoft-office?src=yt_comment

[@golfinfool7233]

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

[@zdravkakamenova7710]

Same issue with my file. Did you find any solution?

[@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?

[@krmynk9307]

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

[@richarddickson3347]

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

[@warezon]

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

[@jeffreymess]

Did you happen to figure out a way around this? I keep trying to get it to run Show_Sheets or Workbook_Open when cancel is selected but I can't seem to get it to work.

[@warezon]

I did something in my last job but I don’t have the files to check it…

[@chem7rn502]

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??

[@TeachExcel]

When you saved the file, you probably also had allowed the macros to run for the file before you did that and this screen is only meant to display IF the user did not enable macros. So, if the macros have been enabled, then they will never see this screen or worksheet tab. You can change the behaviour to display it every time the workbook opens, but that was just not the purpose of this tutorial and that's why I didn't include it. You can ask for help customizing it in the forum on TeachExcel.com if you'd like, but if you do that, make sure to provide a link to the tutorial where the file can be downloaded so it will be easier for someone there to help :)

[@mokhos1918]

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?

[@TeachExcel]

Just unprotect it, timestamp it, and re-protect it. You can do it like this: Sheets("Sheet Name").Unprotect and then Sheets("Sheet Name").Protect If you have a password, just put it immediately after the Protect or Unprotect. If you need more help, feel free to ask on our forum :) www.teachexcel.com/talk/microsoft-office?src=yt

[@wayneedmondson1065]

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

[@TeachExcel]

Thanks! I appreciate it :)