After choosing your certificate you must save the file.


Gord

On Sun, 22 Mar 2009 13:55:02 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

For Pierre

Set your macro security settings to "Disable with notification" and you will
get the option to enable or disable macros when you open the workbook.

If you don't want to deal with the warning you can sign the workbook with
the selefcert DS you created.

If you have already created a selfcert DS you will find it the Management
Console under Personal Signatures after loading the Signatures Snap-in.

Steps............after closing Excel

StartRun mmc

Load the MMC digital signature snap-in from FileAdd/Remove Snap-in

Select Certificates and Certificates-Current User

Open Personal folder.

You must copy the selfcert DS from Personal Signatures to Trusted Publishers

Then...............................

With your workbook open and in VBE, select ToolsDigital SignaturesChoose

Your selfcert DS will be available for signing that workbook.


Gord Dibben MS Excel MVP


On Sun, 22 Mar 2009 16:06:53 -0400, "Rick Rothstein"
wrote:

I've never worked with digital signatures, so I'm not sure what I can do to
help you out there. I think there is a way that you can digitally self-sign
your macros (which would mean you could copy/paste the code into your own
work and then digitally sign that). Perhaps someone familiar with the
process will come along and follow up on this for you. You could consider
lowering your security setting and visually analyze/examine any macros
before you implement them in your own workbooks (the setting you are
currently using would be most effective if you take in workbooks from other
sources and try to run them on your own system... I wouldn't think code you
create or implement should not require such a high setting. Also, trying
them out on a copy of your workbook so they can't accidentally affect any of
your original data is something you might also consider.