Digitally sign VBA Project at run time

[Sharad Naik]

During run time, I copy a sheet save it as a new workbook and mail it. The
sheet has macros in the Sheet class.
The parent workbook code is digitally signed.

Is it possible to digitally sign at run time? how?
Thanks
Sharad

 

[Stephen Bullen]

Hi Sharad,

During run time, I copy a sheet save it as a new workbook and mail it. The
sheet has macros in the Sheet class.
The parent workbook code is digitally signed.

Is it possible to digitally sign at run time? how?

One method is to start off with an empty workbook template, containing a
digitally signed project. Then instead of copying the sheet to a new workbook,
create a new copy of the template file and copy it to that.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk

 

[Sharad Naik]

Thanks Stephan,
Looks like this will be the solution for me.

Sharad