View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Barn E. Fife Barn E. Fife is offline
external usenet poster
 
Posts: 9
Default copy my digital certificates?

Not to whine at you Gord - I truly appreciate your great interest and
effort - but I appeal to anyone if they learn a way to adapt the
existing certs (or maybe create new ones with the same name that
work). I just hate to burn the file dates which are invaluable
history. (If there's no other way out, I will probably cobble
together some sort of file date touching mechanism with a .BAT file.
If the loony-toon Microsoft design baboons don't insanely destroy DOS
prompts and .BATs first, I may go something like
readdate %1 c:\tempdate.tmp
excel.exe %1
stampdat %1 c:\tempdate.tmp

On Dec 15, 10:20*pm, Gord Dibben wrote:
Build a new one and start adding to each workbook as you run into the nag..

I use one for all my workbooks in 2003................not needed in 2007

Gord

On Thu, 15 Dec 2011 14:15:13 -0800 (PST), "Barn E. Fife"


wrote:
Alas, yes, I'm in author mode, but impotent.


One more look<g


I'll take it, and anyone else who has the answer, now or months later
- because it's quite an aggravation - all day long I'm answering macro
nags on my own files. *'Fer cryin' out loud, I backed up the selfcert
certificates! *But so far, seemingly to no avail.


Since I chopped off the quote trail, if anyone needs it: I reinstalled
XP and Office 2003 (and 2007 coexisting, because I enjoy torture), SP2-
d Office2003, copied contents of \keys and \certificates directories
from backup ... and hoped that would allow my old selfcert
certificates to avert macro warnings for my own files.


On Dec 15, 2:12*pm, Gord Dibben wrote:
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.