Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox "Always trust macros from this source" shaded out
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox "Always trust macros from this source" shaded out
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox "Always trust macros from this source" shaded out
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox "Always trust macros from this source" shaded out
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox "Always trust macros from this source" shaded out
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox "Always trust macros from this source" shaded out
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox "Always trust macros from this source" shaded out
Hi:
I am having the same problem. In knowledge base article, some where, I read that system administrator can certify my certificate. I am not sure how to do it. Also excel is loaded on each machine in my office. I like my coworkers to use the macros. MVM "Stephen Bullen" wrote: Hi Valeria, 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? No idea, I'm afraid. See if this helps (watch for word-wrap in the URLs): http://msdn.microsoft.com/library/de...vbaproject.asp Regards Stephen Bullen Microsoft MVP - Excel www.oaltd.co.uk |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox "Always trust macros from this source" shaded out
I have tried again, and it works now in my case (I do not know why it was not
working before). I did the following: exported my self-certificate signed of course all the macros with it sent the certificate to my colleagues told them to install it in the following way: open it -- click on "install" -- "next" -- "Place all certificates in the following store" (not the default option!) -- "browse" -- "Trusted root cerification authorities" -- OK, next, ok etc Now, when they open the workbooks, they can click on "always trust macros from this source", and if they do it, they do not get the macro warning again... It might be that your problem lies in the fact that your company has locked the "trusted root certification authorities group, so your coworkers can't add your certificate... hope this helps, best regards, Valeria "MVM" wrote: Hi: I am having the same problem. In knowledge base article, some where, I read that system administrator can certify my certificate. I am not sure how to do it. Also excel is loaded on each machine in my office. I like my coworkers to use the macros. MVM "Stephen Bullen" wrote: Hi Valeria, 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? No idea, I'm afraid. See if this helps (watch for word-wrap in the URLs): http://msdn.microsoft.com/library/de...vbaproject.asp Regards Stephen Bullen Microsoft MVP - Excel www.oaltd.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why do i "sometimes" need to "edit chart object" before "source da | Charts and Charting in Excel | |||
Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
How to check "Always trust macros from this published" when securityis set to high? | Excel Programming | |||
Registry key for "Trust access to Visual Basic project" | Excel Programming | |||
always trust macros from this source - is disabled. Why? | Excel Programming |