How to create a digital certificate...

[hermes]

so that I can use it to locally sign my office files (word and excel). I
do not want to continue to be prompted to enable or disable macros for
each of my files that I open if they have a macro. I am not allowed
(nor would I care to) change the macro security setting from medium to
low. I have already created a digital certificate to locally sign my
office files with, but the problem is that there is no checkbox for the
"always trust macros from this source" so that it can stop prompting me
to enable or disable macros! I can't find it anywhere. I run office XP
pro.

Another question I have is why does saving a office file remove all
digital signatures from it? Any suggestions please? Thanks.

 

[Milly Staples [MVP - Outlook]]

Did you use selfcert.exe to create your certificate?

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After searching google.groups.com and finding no answer, hermes asked:

| so that I can use it to locally sign my office files (word and
| excel). I do not want to continue to be prompted to enable or disable
| macros for each of my files that I open if they have a macro. I am
| not allowed (nor would I care to) change the macro security setting
| from medium to low. I have already created a digital certificate to
| locally sign my office files with, but the problem is that there is
| no checkbox for the "always trust macros from this source" so that it
| can stop prompting me to enable or disable macros! I can't find it
| anywhere. I run office XP pro.
|
| Another question I have is why does saving a office file remove all
| digital signatures from it? Any suggestions please? Thanks.

 

[Biff]

Hi hermes!

I don't know if this will work globally in Office, but it
should work in Excel:

Tools>Macro>Security>Trusted Sources

Macros and add-ins created by trusted sources are
automatically enabled.

Biff

 

[hermes]

Did you use selfcert.exe to create your certificate?

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

Hi Milly and thanks for the reply. Yes, I have used selfcert.exe to
create my certificate. Unfortunately, I can't seem to have the file(s)
with the macro remain signed after I add the certificate to them and
then try to save it. Do I need to sign the macro instead mabey? Also,
I cannot find anywhere the checkbox which says, "always trust macros
from this source", so it prompts for enable or disable macros everytime
anyway.

 

[hermes]

Hi hermes!

I don't know if this will work globally in Office, but it
should work in Excel:

Tools>Macro>Security>Trusted Sources

Macros and add-ins created by trusted sources are
automatically enabled.

Biff

Hi Biff, and thanks for the reply. I have been there, and I don't see
any way to add my certificate there. Can you tell me how please?

(word and excel). I


disable macros for


not allowed


from medium to


locally sign my


checkbox for the


stop prompting me


I run office XP


remove all

--
hermes
DRM sux! Treacherous Computing kills our virtual civil liberties!
http://protectfreedom.tripod.com/
http://www.cl.cam.ac.uk/~rja14/tcpa-faq.html
http://anti-dmca.org/
http://www.eff.org/IP/DMCA/unintended_consequences.php

Windows XP crashed.
I am the Blue Screen of Death.
No one hears your screams.

 

[Gord Dibben]

Hermes

You can create a digital certificate and use that on your VBAProject so only
that file with the certificate is allowed to be opened with no warning.

You can get to SelfCert either of these ways........

1. Start>Programs>Microsoft Office>Tools>"Digital Certificate for VBA
Projects"

2. Open Windows Explorer and drill down to your Office folder. Find
SelfCert.exe and run it.

This certificate is good only on your computer but can be used for more than
one file.

Once the certificate has been created and with your file open, go to the
VBEditor and select your VBAproject/file.

Tools>Digital Signature>Choose. Select the Certificate you just created.

OK your way out and save your file.

Next time you open this particular file you will not get the warning.

NOTE: DC's are not available for Excel 97

If you still have trouble with this, post back and we can walk through adding
a selfcert to the trusted certificates store via Windows Microsoft Management
Console.

Gord Dibben Excel MVP

Did you use selfcert.exe to create your certificate?

--?
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

Hi Milly and thanks for the reply. Yes, I have used selfcert.exe to
create my certificate. Unfortunately, I can't seem to have the file(s)
with the macro remain signed after I add the certificate to them and
then try to save it. Do I need to sign the macro instead mabey? Also,
I cannot find anywhere the checkbox which says, "always trust macros
from this source", so it prompts for enable or disable macros everytime
anyway.

After searching google.groups.com and finding no answer, hermes asked:

| so that I can use it to locally sign my office files (word and
| excel). I do not want to continue to be prompted to enable or disable
| macros for each of my files that I open if they have a macro. I am
| not allowed (nor would I care to) change the macro security setting
| from medium to low. I have already created a digital certificate to
| locally sign my office files with, but the problem is that there is
| no checkbox for the "always trust macros from this source" so that it
| can stop prompting me to enable or disable macros! I can't find it
| anywhere. I run office XP pro.
|
| Another question I have is why does saving a office file remove all
| digital signatures from it? Any suggestions please? Thanks.

 

[hermes]

Hermes

You can create a digital certificate and use that on your VBAProject so only
that file with the certificate is allowed to be opened with no warning.

You can get to SelfCert either of these ways........

1. Start>Programs>Microsoft Office>Tools>"Digital Certificate for VBA
Projects"

2. Open Windows Explorer and drill down to your Office folder. Find
SelfCert.exe and run it.

This certificate is good only on your computer but can be used for more than
one file.

Once the certificate has been created and with your file open, go to the
VBEditor and select your VBAproject/file.

Tools>Digital Signature>Choose. Select the Certificate you just created.

OK your way out and save your file.

Next time you open this particular file you will not get the warning.

NOTE: DC's are not available for Excel 97

If you still have trouble with this, post back and we can walk through adding
a selfcert to the trusted certificates store via Windows Microsoft Management
Console.

Gord Dibben Excel MVP

Gord, it worked like a charm! Thanks.

Milly Staples [MVP - Outlook] wrote:

Did you use selfcert.exe to create your certificate?

--?
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

Hi Milly and thanks for the reply. Yes, I have used selfcert.exe to
create my certificate. Unfortunately, I can't seem to have the file(s)
with the macro remain signed after I add the certificate to them and
then try to save it. Do I need to sign the macro instead mabey? Also,
I cannot find anywhere the checkbox which says, "always trust macros

from this source", so it prompts for enable or disable macros everytime

 

[Gord Dibben]

Thanks for the feedback, Hermes.

Good to know what works or doesn't.

Gord

 

[routeram]

Hi,

I don't know as to why there is no checkbox. I have used selfcert onc
or twice but never encountered this problem.

With regard to your second question, the digital signature is broke
each time you change and save the code. Once the signature is broken
the user is notified of a broken signature when opening a workbook
This way the user knows that the code was altered and probably not saf
to run.

As far as I know the code should be broken only if signed at
particular computer and altered at a different computer or the sam
computer by a different user. This is because the encoding algorith
makes use of some information that is unique to the computer and use
to make the encoded certificate (I guess so)

Hope I was clear.

Ram