VB and VBA Users Source Code: Re: Enable and disable Excel's macro virus protection

VB/VBA Source Code
Re: Enable and disable Excel's macro virus protection

By:	MRH
Email (spam proof):	Email the originator of this post
Date:	Sunday, September 08, 2002
Hits:	1111
Category:	Office

Article:
I have a VBA program which starts automatically when the workbook is open using the "auto_open" sub routine. I would like to use this piece of code to disable the macro virus protection so the user doesn't see the pop up dialog box. My question is how will this code work if the virus protection checkbox has been checked i.e. Excel will automatically look for any macros attached to the workbook before excuting the disable macro protection code. Hence it will always ask the user before the code is excuted? Where should the code go? At present I have referred to the function in my "auto_open" sub. This doesn't work. Any help with this would be appreciated. Thanks, MRH
Terms and Conditions
Support this site Download a trial version of the Excel Workbook Rebuilder