Digitally sign VBA Project at run time
 

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

Digitally sign VBA Project at run time
 

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

Digitally sign VBA Project at run time
 

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

Sharad

"Stephen Bullen" wrote in message
...
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