View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Signing VBA code within an Excel spreadsheet from VBA

Martin,

I believe that you need to use a template file that is already signed as the
basis of your files created on the fly.

HTH,
Bernie
MS Excel MVP

"Martin Waller" wrote in message
...
Hello,

I have a system where I dynamically create XLS files on the fly by
automating Excel 2003. The XLS files contain VBA code that is injected,
again via automation, and I'd like to know if it is possible to

dynamically
sign the code too - again on the fly and not by the dialogs.

Any help would be much appreciated...

Martin