Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 468
Default Use of SelfCert Digital Signature

I have 2,000 macro files on my Home-office PC.
While creating and saving these over the years
I didn't know anything about SelCert DS to save me
from having to click on the ENABLE-MACRO Screen
which appears anytime I open any one of them.

I have created a Seft Cert and in testing have got it
working.. It seems that I want now to Go in on the
1900+ previously written files and assign my "JM" (Cert name) to each.

This SCARES ME TO (Near) DEATH !! Any time you think
you are about to do something GREAT - It usually ends up
Biting you in the BUTT Or WORSE.

Two Questions...
1) As all these (1900) are in the same FolderName, is there
a Macro (written) that can do this on all my files at one time?
Right now I have on the first 3 I've converted, manually
a) Opened,
b) Switched to the VBE,
c) Tools, Digital Signature
d) Choose..
e) With JM visible and auto-Selected - Click OK, OK
f) File, Save, Close.

Quite a series of strokes to do 1,900 times....

#2 Question:
What is going to Happen -- BAD to ME?

a 3rd Question - If I send the file to someone as an e-mail attachment
(I know there will be some prob as they will not have the CertName,
but at this point I fail to understand what if anything they can do.. must I
remove my Cert from th eFile before sending? << Is that the simple answer?

HELP !!
Thanks in Advance..






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot add digital signature to macros RealGomer Setting up and Configuration of Excel 3 May 2nd 07 10:22 PM
Digital Signature Sandy Mann Excel Discussion (Misc queries) 5 January 12th 06 12:58 AM
Digital signature TLS Excel Discussion (Misc queries) 0 June 4th 05 06:34 AM
digital certificate for my macros with SelfCert.exe MVM Excel Discussion (Misc queries) 1 January 26th 05 10:38 PM
Digital Signature Gets Removed By Itself Kenjiro Yagi Excel Worksheet Functions 0 December 2nd 04 10:20 AM


All times are GMT +1. The time now is 02:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"