How to create a digital certificate...

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

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.

Hi hermes!

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

ToolsMacroSecurityTrusted Sources

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

Biff

-----Original Message-----
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
.

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
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

Biff wrote:

Hi hermes!

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

ToolsMacroSecurityTrusted 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?



-----Original Message-----
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
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.

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. StartProgramsMicrosoft OfficeTools"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.

ToolsDigital SignatureChoose. 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

On Tue, 29 Jun 2004 08:12:29 -0500, hermes wrote:

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
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.

Gord Dibben wrote:

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. StartProgramsMicrosoft OfficeTools"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.

ToolsDigital SignatureChoose. 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.


On Tue, 29 Jun 2004 08:12:29 -0500, hermes wrote:


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

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

Thanks for the feedback, Hermes.

Good to know what works or doesn't.

Gord

On Tue, 29 Jun 2004 11:39:00 -0500, hermes wrote:

Gord, it worked like a charm! Thanks.

Hi,

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

With regard to your second question, the digital signature is broken
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 safe
to run.

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

Hope I was clear.

Ram

hermes wrote:
*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 *


---
Message posted from http://www.ExcelForum.com/