Excel Tutorials

Thursday, January 05, 2006

Forcing Users to Enable Macros

Have you ever distributed a workbook to many clients, only to find out that they are not enabling macros? Well in the linked video, I show you a relatively simple way to force your users to enable macros with only four lines of code.

http://www.datapigtechnologies.com/flashfiles/forcemacros.html

posted by Mike Alexander at 11:36 PM

2 Comments:

  • Mike:

    Great concept. 1 issue I'm having using your code. Upon completion and exit of the workbook, the warning sheet appears along with a "do you want to save" message. How can the warning sheet be suppressed when asking if the user wants to save?

    By Anonymous Anonymous, At 1:20 AM  

  • Use Enter this line of code
    Application.DisplayAlerts = False

    By Blogger Mike Alexander, At 12:24 AM  

Post a Comment

Subscribe to Post Comments [Atom]



<< Home