View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default 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 )