If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
How to create a digital certificate...
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. |
#3
|
|||
|
|||
How to create a digital certificate...
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 . |
#4
|
|||
|
|||
How to create a digital certificate...
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 |
#5
|
|||
|
|||
How to create a digital certificate...
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. |
#6
|
|||
|
|||
How to create a digital certificate...
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. |
#7
|
|||
|
|||
How to create a digital certificate...
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 |
#8
|
|||
|
|||
How to create a digital certificate...
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. |
#9
|
|||
|
|||
How to create a digital certificate...
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/ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Digital Signature in Outlook 2003 Problem | John Williams | General Discussion | 0 | June 24th, 2004 06:00 AM |
create table using access 2000 connecting to SQL Server 2000 | Chris | Running & Setting Up Queries | 0 | June 11th, 2004 06:41 PM |
When I try to open/save .rtf attachment I get the messages ?Can't create file. Right-click the folder you want to create item in and then click on the shortcut menu to check your permissions for the folder.? | Nie Geweune via AdminLife | Installation & Setup | 0 | April 27th, 2004 11:16 AM |
How to create transparent objects on images in Excel | Simon Lenn | Charts and Charting | 1 | December 23rd, 2003 05:12 AM |