Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot add digital signature to macros | Setting up and Configuration of Excel | |||
Digital Signature | Excel Discussion (Misc queries) | |||
Digital signature | Excel Discussion (Misc queries) | |||
digital certificate for my macros with SelfCert.exe | Excel Discussion (Misc queries) | |||
Digital Signature Gets Removed By Itself | Excel Worksheet Functions |