Dear experts,
I have electronically signed my macros to enable my coworkers to simply
check the checkbox "Always trust macros from this source" in the macro
security alert, and not be bothered with it anymore.
It works on my computer, but in some other computers the checkbox line is
grey and you can't check it. The security level for macros is medium on every
computer.

What could the reason for this be? Can you please help me?
Many thanks!
Valeria

Hi Valeria,

I have electronically signed my macros to enable my coworkers to simply
check the checkbox "Always trust macros from this source" in the macro
security alert, and not be bothered with it anymore.
It works on my computer, but in some other computers the checkbox line is
grey and you can't check it. The security level for macros is medium on every
computer.

What could the reason for this be? Can you please help me?

The reason is probably that you used SelfCert to create the certificate, which
only allows you to trust the cert for your machine.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk

Hi,
yes, I used SelfCert... what else should I use to enable the "Always trust
macros from this source" option on other computers?
Thank you!
Best regards,
Valeria

"Stephen Bullen" wrote:

Hi Valeria,

I have electronically signed my macros to enable my coworkers to simply
check the checkbox "Always trust macros from this source" in the macro
security alert, and not be bothered with it anymore.
It works on my computer, but in some other computers the checkbox line is
grey and you can't check it. The security level for macros is medium on every
computer.

What could the reason for this be? Can you please help me?

The reason is probably that you used SelfCert to create the certificate, which
only allows you to trust the cert for your machine.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk

Hi Valeria,

yes, I used SelfCert... what else should I use to enable the "Always trust
macros from this source" option on other computers?

If it's only one or two computers that you 'control' (e.g. work colleagues),
you might be able to get away with exporting the signature from your machine
and installing it on theirs. Use Control Panel Internet Options Content
Certificates to export/import the certificate.

For more general distribution, you need to purchase a proper digital
certificate from someone like Thawte (www.thawte.com) or Verisign
(www.verisign.com)

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk

Hi Stephen,
thank you, I'll try exporting my certificate. A very last question: when I
try to export it, a window is opened asking me for the path and type of the
certificate. I could not locate it! Where is it normally installed?

Many thanks,
best regards,
Valeria

"Stephen Bullen" wrote:

Hi Valeria,

yes, I used SelfCert... what else should I use to enable the "Always trust
macros from this source" option on other computers?

If it's only one or two computers that you 'control' (e.g. work colleagues),
you might be able to get away with exporting the signature from your machine
and installing it on theirs. Use Control Panel Internet Options Content
Certificates to export/import the certificate.

For more general distribution, you need to purchase a proper digital
certificate from someone like Thawte (www.thawte.com) or Verisign
(www.verisign.com)

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk

Hi Stephen,
I have figured out I just had to give a name to the certificate (please
ignore my previous post), so I have succesfully exported it and installed it
on my collegue's machine.
I have tried storing it under "personal cert", or "other users", etc but the
check box of the macro alert is still greyed out!
What am I doing wrong?
Thanks, best regards,
Valeria

"Stephen Bullen" wrote:

Hi Valeria,

yes, I used SelfCert... what else should I use to enable the "Always trust
macros from this source" option on other computers?

If it's only one or two computers that you 'control' (e.g. work colleagues),
you might be able to get away with exporting the signature from your machine
and installing it on theirs. Use Control Panel Internet Options Content
Certificates to export/import the certificate.

For more general distribution, you need to purchase a proper digital
certificate from someone like Thawte (www.thawte.com) or Verisign
(www.verisign.com)

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk