Only some users can tell Excel, that macros made by me is safe

[Kenneth Andersen]

Hi

I'm making several workbooks that other users will use. These workbooks
oftent contains macros, and I sign the macros with a digital signature.
Thereby some users (but not all) can tell Excel, that they trust macros that
has been digitally signed by me - and they get rid of the question about
opening the workbook with or without macros.

My question is, why it is not all users that can tell excel, to trust my
macros - or even better, my question is how the last users will be able to
trus my macros.

Some users run on Windows 2000 while other run on Windows XP, but this
doesn't seem to be the reason. We all have the macro safetylevel set to
medium.

I hope someone can help me on this.

Thanks.

 

[Kevin B]

Verify that you're listed as a TRUSTED PUBLISHER in the security table.

On the PC's where you're signature is accepted, click TOOLS, MACRO and
select SECURITY. Click the TRUSTED PUBLISHERS tab and verify that you're in
that list, and if not you'll have to be added.

 

[Kenneth Andersen]

Hi Kevin

Thank you for trying to help me. I need to mention, that I use a Danish
version of Excel, which may cause that I'm translating something from Excel
wrong - I hope you understand the things I write.

In that window where I'm asked if I want to open the workbook with or
without macros, it is normally possible to set a mark, to tell excel that
macros from this person is trusted (this is only available when the macros in
the workbook is digitally signed, which is the case here) - but this field is
gray and thereby not optional - some users can set this mark without any
problems.

I cannot ad me as a trusted publisher as far as I can see.

I hope you can help me further.

Kenneth Andersen



"Kevin B" skrev: