Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 212
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 205
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 212
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you digitally sign your own macros? FARAZ QURESHI Excel Discussion (Misc queries) 1 September 13th 08 05:32 PM
Digitally signing VBA Project Michelle Excel Discussion (Misc queries) 3 November 11th 07 01:25 PM
how to digitally sign a macro? .:mmac:. Setting up and Configuration of Excel 4 December 4th 04 01:27 AM
Can not digitally sign Sharad Naik Excel Programming 4 November 11th 04 04:39 AM
Digitally Sign Macros RK[_5_] Excel Programming 1 April 10th 04 02:44 PM


All times are GMT +1. The time now is 07:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"