Re: Macros are disabled (How to)



Hi Snake,

Thank for your response,

I know how to add a digital signature and all this stuff (I think..)
but it's not that I want to do now, the only thing that bothers me is
how to make excel show the 1st mesage that informs that macros are
disabled (has a button that shows help and how to enable macros...), I
don't know which are the "parameters" cause that again.

PS: Don't spent much time about this issue although I very much
appreciate it!!!

Thanks again

Snake Plissken wrote:
Hi guys,

Indeed, I know how to disable and enable macros but I want to provoke
the message to appear when my security level is set to High and the
file opens for the first time.


As I understood:
- the file contains macros and you want them to be there ( macros should be
functional I assume ? )
- you want security level set to High. Neverthless you want to see warning
message

Then I think you could add your own digital signature (private certificate)
to VBA projects so users would be warned that file contains macro written by
you and they may decide wether it should be switch on (optionally they could
install your certivicate so every macro signed with this certificate would
open without promt message). The file that opens program creating private
certificates is: selfcert.exe (I dont remember if all office versions works
this way)
Does it help ?

regards,

S.

.