macro not digitally signed

[vb_student]

Hello
I have got macros "embedded(?)" in my excel spreadsheet and when i open it, it says

"Macros in this workbook are disabled because the security level is high, and the macros have not been digitally signed or verified as safe. To run the macros, you can either have them signed or change your security level. Click help for more information"

what is a ddigitally signed macro and how can i digitally sign a macro

also how can i reduce the security level of my excel spreadsheet?

[RobDog888]

Checkout my CodeBank code on creating and using a Digital Signature.

[vb_student]

thanks dude

[shiamak]

Checkout my CodeBank code on creating and using a Digital Signature.

Hi There,

IS there a way to automate the digital signing process? using VB6 or VB .NET.

I have verisign digital cert and most of time I get 50 to 100 .dot templates to sign, opening each template and then applying signature is a big pain for that number of templates.....

Any help is appreciated.

BTW: I have looked at SignatureSet and Signature object but to no help.

TIA

[RobDog888]

You might be able to automate it by opening a doc, opening the vba editor, then invoking the menus to sign the project but may be flakey using SendKeys unless you switched it to use API code but thats allot more work.

[shiamak]

You might be able to automate it by opening a doc, opening the vba editor, then invoking the menus to sign the project but may be flakey using SendKeys unless you switched it to use API code but thats allot more work.

Indeed a document can be opened hence the VBA Editor but this way iwill have to open each document to sign, I am just wondering if there is a way to sign them in the backround?

I willing to do/write code..the way it is needed. Please give me exmples if possible.

TIA

[RobDog888]

I didnt see anything promissing but have you tried recording a macro and see if it gets recorded?