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??
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??