ANmarS - Portfolio - EnableMacros

Excel/VBA expert since Sep 1997 (19 years 6 months)

EnableMacros    Added: 6/20/2011 | Created: 8/20/2011   

New release found here (WelcomeSheet)

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 (896.7 KB)

1063 downloads | Last updated: 1/15/2014

Screen shots (12)