Security Signing of VBA Code
 

Can anyone enlighten me on how to obtain a digital signature for Excel VBA
code that I might wish to share with, or make commercially available to,
others. Currently, the user must lower the Macro Security level down to
allow my code to run. This is not desirable in many offices where the local
IT guy has concerns about viruses.

Who issues digital signatures? What is the process? What does it cost?

I am sure that this group knows all about the subject.

Dan Fisher

Security Signing of VBA Code
 

u can generate ur own private digital key : just find file selfcert.exe
then make ur own certificate. Then u must add this certificate to every vba
project u wonna sign (vba options: tools\digital signature...)
After this user will be notified that file is signed by ur signature and
can decide wheather insall this certificate or not. If one agree this file
will open without macro warning prompt but vba code mustn't be modified on
any other machine than urs ( or certificate will be removed from modified
file )

G.

Security Signing of VBA Code
 

Snake Plissken wrote

Then u must add this certificate to every vba
project u wonna sign (vba options: tools\digital signature...)

I'm exploring this option, too. I have workbooks that contain sheet level,
workbook level and module level code. Do I have to add to each? Each Sub()
within each? What about Forms?

If one agree this file will open without macro warning prompt but vba
code mustn't be modified on any other machine than urs (or certificate
will be removed from modified file)

Well, that defies the term 'Security', does it not?

Trying to understand.

--
David

Security Signing of VBA Code
 

I'm exploring this option, too. I have workbooks that contain sheet
level,
workbook level and module level code. Do I have to add to each? Each
Sub()
within each? What about Forms?

u sign only project ( project includes every object within opened file )

If one agree this file will open without macro warning prompt but vba
code mustn't be modified on any other machine than urs (or certificate
will be removed from modified file)

Well, that defies the term 'Security', does it not?

right - only author can modify own projects without removing the
certificate from certain file ( author means user logged on his machine -
as far as i remember both info is stored in certificate )

Security Signing of VBA Code
 

I remember reading a Microsoft article a couple years back that you can make
a portable certificate that will allow you to work on a project from 2
different machines without one trashing the others cert. I never followed up
on trying it though, I still let work and home trash each others cert.

Mike F
"Snake Plissken" wrote in message
...




I'm exploring this option, too. I have workbooks that contain sheet
level,
workbook level and module level code. Do I have to add to each? Each
Sub()
within each? What about Forms?

u sign only project ( project includes every object within opened file )

If one agree this file will open without macro warning prompt but vba
code mustn't be modified on any other machine than urs (or certificate
will be removed from modified file)

Well, that defies the term 'Security', does it not?

right - only author can modify own projects without removing the
certificate from certain file ( author means user logged on his machine -
as far as i remember both info is stored in certificate )

Security Signing of VBA Code
 

Not sure self cert is the way to go if this is going to be something you
sell. You might check out these articles:

nything in these to help?



http://msdn.microsoft.com/library/de.../odc_dsvba.asp
Code Signing Office XP Visual Basic for Applications Macro Projects

http://support.microsoft.com/default...;en-us;Q288985
XL2002: About Digital Signatures in Excel Workbooks

http://support.microsoft.com/default...38&Product=ofw
About Digital Signatures and Code Signing in Workbooks in Excel 2003

http://support.microsoft.com/?KBID=206637
OFF2000: Overview of Digital Certificates (Q206637)

http://support.microsoft.com/?KBID=217221
OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
(Q217221)

An Overview:
http://msdn.microsoft.com/library/de...tml/combat.asp

Another reference:
http://msdn.microsoft.com/library/en...vbaproject.asp



http://support.microsoft.com/default...;en-us;Q329228
OFFXP: How to Make Sure That Your Office Document Has a Valid Digital
Signature


http://office.microsoft.com/assistan...ustworthy.aspx
How to Tell if Digital Certificate Is Trustworthy in Office XP

Regards,
Tom Ogilvy




"Dan Fisher" wrote in message
news:hzAJe.77983$4o.44506@fed1read06...
Can anyone enlighten me on how to obtain a digital signature for Excel VBA
code that I might wish to share with, or make commercially available to,
others. Currently, the user must lower the Macro Security level down to
allow my code to run. This is not desirable in many offices where the
local
IT guy has concerns about viruses.

Who issues digital signatures? What is the process? What does it cost?

I am sure that this group knows all about the subject.

Dan Fisher

Security Signing of VBA Code
 

makecert.exe (rather than selfcert) allows you to make a portable key.

http://www.source-code.biz/snippets/vbasic/3.htm

HTH,
Gareth

Mike Fogleman wrote:
I remember reading a Microsoft article a couple years back that you can make
a portable certificate that will allow you to work on a project from 2
different machines without one trashing the others cert. I never followed up
on trying it though, I still let work and home trash each others cert.

Mike F
"Snake Plissken" wrote in message
...



I'm exploring this option, too. I have workbooks that contain sheet
level,
workbook level and module level code. Do I have to add to each? Each
Sub()
within each? What about Forms?

u sign only project ( project includes every object within opened file )


If one agree this file will open without macro warning prompt but vba
code mustn't be modified on any other machine than urs (or certificate
will be removed from modified file)

Well, that defies the term 'Security', does it not?

right - only author can modify own projects without removing the
certificate from certain file ( author means user logged on his machine -
as far as i remember both info is stored in certificate )