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 @ 11:36 PM
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?
posted by Anonymous Anonymous : 1:20 AM
 
Use Enter this line of code
Application.DisplayAlerts = False
posted by Blogger Mike Alexander : 12:24 AM
 

Post a Comment


<< Home

 

 

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. This weblog is in no way associated with Microsoft.

This page is powered by Blogger. Isn't yours?