Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy my digital certificates?
I had to reinstall Office 2003 after assigning many files to my
digital certificate made by selfcert. Of course, I'm getting the macro nag every time from Excel 2003 (I'm on medium security). I don't want to resign and resave every .xls I can find, if for no other reason that I'd pervert the file dates for no "meaningful" reason. And even if I think I fixed them all, from time to time I'd get hit, even though I signed them with the express intent to sail right in without warning, at least on my own machine. I found the old certificates that were backed up from C:\Documents and Settings\MyNameHere\Application Data\Microsoft\SystemCertificates\My \Certificates . I copied them back in following the reinstall of Office 2003 and SP2. Is there another step I can take to put me back in the "smooth sailing" I had before? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy my digital certificates?
You may have to see if they are registered/stored in your Personal
Certificates Store. StartRun mmc This opens the Management Console. FileAdd Snap-in........Certificates Look in Personal and Trusted Publisher If they are in there then your restoration would seem to be complete. I have never restored as you did so no idea if simply putting them back into the folder is adequate. Gord On Wed, 14 Dec 2011 16:21:23 -0800 (PST), "Barn E. Fife" wrote: I had to reinstall Office 2003 after assigning many files to my digital certificate made by selfcert. Of course, I'm getting the macro nag every time from Excel 2003 (I'm on medium security). I don't want to resign and resave every .xls I can find, if for no other reason that I'd pervert the file dates for no "meaningful" reason. And even if I think I fixed them all, from time to time I'd get hit, even though I signed them with the express intent to sail right in without warning, at least on my own machine. I found the old certificates that were backed up from C:\Documents and Settings\MyNameHere\Application Data\Microsoft\SystemCertificates\My \Certificates . I copied them back in following the reinstall of Office 2003 and SP2. Is there another step I can take to put me back in the "smooth sailing" I had before? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy my digital certificates?
Great reply. But Add Snap-in only shows an empty box; the dropdown
above only shows "Console Root" . So I clicked the add button for certificates which put "Certificates - Current User" in the box (indented under Console Root in the dropdown). But that's as far as I can go there, beyond clicking About. On the Extensions tab everything is grayed. In case it matters, I am not an Admin on this box, but can call one down. What you wrote did empower me to discover http://office.microsoft.com/en-us/ex...001161864.aspx which looks like a genuinely useful (difficult for me to say when speaking of Microsoft!) "learning course" on digital certificates and macros. Quickly reading through it didn't appear to address my present "restore" objective though. As an aside, another desire would be to be able to pass a certificate to a workmate so they are liberated from the warning prompt on my creations - and I from warnings on theirs, if we both signed with it. Could they just say they trust it, even though there's no according-to- Hoyle certificate authority? That answer appears to be no from my reading of http://office.microsoft.com/en-gb/he...003089291.aspx which says that self-cert is for one machine only. Barney It's Fife! Not Google! On Dec 14, 6:56 pm, Gord Dibben wrote: You may have to see if they are registered/stored in your Personal Certificates Store. StartRun mmc This opens the Management Console. FileAdd Snap-in........Certificates Look in Personal and Trusted Publisher If they are in there then your restoration would seem to be complete. I have never restored as you did so no idea if simply putting them back into the folder is adequate. Gord On Wed, 14 Dec 2011 16:21:23 -0800 (PST), "Barn E. Fife" wrote: I had to reinstall Office 2003 after assigning many files to my digital certificate made by selfcert. Of course, I'm getting the macro nag every time from Excel 2003 (I'm on medium security). I don't want to resign and resave every .xls I can find, if for no other reason that I'd pervert the file dates for no "meaningful" reason. And even if I think I fixed them all, from time to time I'd get hit, even though I signed them with the express intent to sail right in without warning, at least on my own machine. I found the old certificates that were backed up from C:\Documents and Settings\MyNameHere\Application Data\Microsoft\SystemCertificates\My \Certificates . I copied them back in following the reinstall of Office 2003 and SP2. Is there another step I can take to put me back in the "smooth sailing" I had before? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy my digital certificates?
I don't know what to say about loading the Snap-in but not displaying
the list. I have a user on my computer who has no Admin rights but is able to access the list of Certificates. When you click on FileAdd/Remove Snap-ins do you get a long list of available snap-ins? Are you able to select Certificates and hit the Add button to add to the right-side panel? As far as transferring a self-cert to another computer.........you cannot. You have no signed key for that type of certificate. That would be necessary to export the certificate to another computer. Gord On Thu, 15 Dec 2011 08:25:35 -0800 (PST), "Barn E. Fife" wrote: Great reply. But Add Snap-in only shows an empty box; the dropdown above only shows "Console Root" . So I clicked the add button for certificates which put "Certificates - Current User" in the box (indented under Console Root in the dropdown). But that's as far as I can go there, beyond clicking About. On the Extensions tab everything is grayed. In case it matters, I am not an Admin on this box, but can call one down. What you wrote did empower me to discover http://office.microsoft.com/en-us/ex...001161864.aspx which looks like a genuinely useful (difficult for me to say when speaking of Microsoft!) "learning course" on digital certificates and macros. Quickly reading through it didn't appear to address my present "restore" objective though. As an aside, another desire would be to be able to pass a certificate to a workmate so they are liberated from the warning prompt on my creations - and I from warnings on theirs, if we both signed with it. Could they just say they trust it, even though there's no according-to- Hoyle certificate authority? That answer appears to be no from my reading of http://office.microsoft.com/en-gb/he...003089291.aspx which says that self-cert is for one machine only. Barney It's Fife! Not Google! On Dec 14, 6:56 pm, Gord Dibben wrote: You may have to see if they are registered/stored in your Personal Certificates Store. StartRun mmc This opens the Management Console. FileAdd Snap-in........Certificates Look in Personal and Trusted Publisher If they are in there then your restoration would seem to be complete. I have never restored as you did so no idea if simply putting them back into the folder is adequate. Gord On Wed, 14 Dec 2011 16:21:23 -0800 (PST), "Barn E. Fife" wrote: I had to reinstall Office 2003 after assigning many files to my digital certificate made by selfcert. Of course, I'm getting the macro nag every time from Excel 2003 (I'm on medium security). I don't want to resign and resave every .xls I can find, if for no other reason that I'd pervert the file dates for no "meaningful" reason. And even if I think I fixed them all, from time to time I'd get hit, even though I signed them with the express intent to sail right in without warning, at least on my own machine. I found the old certificates that were backed up from C:\Documents and Settings\MyNameHere\Application Data\Microsoft\SystemCertificates\My \Certificates . I copied them back in following the reinstall of Office 2003 and SP2. Is there another step I can take to put me back in the "smooth sailing" I had before? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy my digital certificates?
When you click on FileAdd/Remove Snap-ins do you get a long list of
available snap-ins? It's empty Are you able to select Certificates and hit the Add button to add to the right-side panel? I don't show a right side panel on mine (XP SP2) - there's a dropbox, a (currently all white, or empty) pane beneath that and buttons Add,Remove,and About; and OK and Cancel. I can click add and on the popup select Certificates, hit add there, and "Certificates-Current User" appears. That's as far as I get, and the window where you'd expect to see them is empty. And even that choice doesn't persist if I close/reopen MMC. Thanks for your interest and effort to explore this. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy my digital certificates?
One more look<g
Open MMC and FileOptions.........Under Console Mode which option is chosen? I think you might be in User..limited access.....single window. Can you select Author or User-Full access ApplyOK and Save that mode? Close and re-open. Gord On Thu, 15 Dec 2011 09:50:03 -0800 (PST), "Barn E. Fife" wrote: When you click on FileAdd/Remove Snap-ins do you get a long list of available snap-ins? It's empty Are you able to select Certificates and hit the Add button to add to the right-side panel? I don't show a right side panel on mine (XP SP2) - there's a dropbox, a (currently all white, or empty) pane beneath that and buttons Add,Remove,and About; and OK and Cancel. I can click add and on the popup select Certificates, hit add there, and "Certificates-Current User" appears. That's as far as I get, and the window where you'd expect to see them is empty. And even that choice doesn't persist if I close/reopen MMC. Thanks for your interest and effort to explore this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Digital certificates | Excel Programming | |||
About the need for digital certificates | Excel Programming | |||
Digital certificates | Excel Discussion (Misc queries) | |||
Digital certificates | Excel Programming | |||
Digital Certificates | Excel Programming |