A blog for listing new Microsoft Excel tutorials.
Thursday, January 05, 2006Forcing 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
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? Post a Comment
| |
SubscribeExcel Tutorial LinksExcel Templates
Archives
Syndicate |