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