Thank you, I have some doubts.
How works macro signing ?
If I apply a certificate to a template file (xlt), each sheet based on that
template inherits signing ?
Do you have any idea of costs of signing ?

Maurizio Bellantone

"Leith Ross" ha
scritto nel messaggio
...

Hello Maurizio,

Your code looks fine. You say you have to Disable Macros to run the
code. If macros are disabled your code (a macro) won't run. If the
code doesn't execute, you will not be able to password protect the
worksheets.

You can trry a couple of things. Either set your security to low, which
will any macro to run (a dangerous option) or self sign the macro which
will allow it to run because it is now recognized by Windows as safe.
If you are planning to use your code on a network you may require
additional permissions from your administrator.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=556247