PDA

View Full Version : [SOLVED] Bypass "Disable Macros" option



malik641
08-08-2005, 09:16 AM
How can I bypass the "This workbook contains macros...." pop-up at startup???

I know about the digital signature, but is there another way? And how EXACTLY does the digital signature work? Is it compatible with Excel 2000?

The reason that I'm asking is because I have a worksheet that is protected upon the workbook_open event and I noticed that if the sheet's macros is disabled and then unprotected and THEN saved before closed, then the next time somebody opens it and they choose "Disable macros" then the sheet will still be unprotected. And I want it to ALWAYS be protected upon opening. (the same goes for the workbook)

Any suggestions??

Jacob Hilderbrand
08-08-2005, 10:41 AM
Check out this Kb Entry (http://www.vbaexpress.com/kb/getarticle.php?kb_id=578) to see a method of forcing a user to enable macros.

To bypass the warning, you can add a digital signature and add that signature as a trusted source or set macro security to low. Both of these can be easily changed by the user so should not be considered for security.

malik641
08-12-2005, 01:29 PM
Hey thanks DRJ. I couldn't really get it to work the way I want, but I'm marking it solved because when I train employees on how to use my spreadsheet, I specifically tell them to always enable macros. And it wouldn't do too much harm if they ended up with the unprotected document (also, it's HIGHLY doubtful that the situation I described above would happen).

So thanks again DRJ :thumb

Zack Barresse
08-12-2005, 01:41 PM
Another option, an article here at VBAX ...

http://www.vbaexpress.com/forum/articles.php?action=viewarticle&artid=3