WelcomeSheet Added: 6/16/2015 | Created: 5/27/2015
Show one sheet to allow user to enable macros to run your Macro file.
With all code needed to hide sheets before saving, and unhiding sheets after open with macros enabled
This is the updated version of EnableMacros. This one has better ways to manage hiding and showing sheets
An easy way to tell your Excel users to enable macros or the system will not work. The sheet that you as VBA developer need to put in each Excel-VBA app you do, it is a nice way to tell the user to enable macros, I have used this sheet since Excel2000 (and developed it based on user experiences), it helped me a lot to say what I wanted to say about enabling macros, off course it was something differant back then.
You basically have two files one for Excel2003, one for Excel2007 and one for Excel2010, filenames say it all.
Read the "ReadMe.txt" file included in the zip for how to setup. Recent changes: Adding the feature to ask/not ask user to save if he already did that before closing.
Here is a video on how to use it in your macro files.
Download (320.3 KB)
730 downloads | Last updated: 6/17/2015