Can not digitally sign

[Sharad Naik]

My project contains Workbook_Open / BeforeClose, etc. macros.

When I try to digitally sign the project and try to save it, I get following
error:-

"This workbook contains Excel 4.0 macros. Workbook containing these macros
can not be singed. Remove the Excel 4.0 macro sheets, and then try the
signing operation."

My current excel version is Office Excel 2003 (SP1).

The macros were created in excel 2000.

How do I now digitally sign my project? Any help will be greatly
appreciated.

(By the way, the projects I created in Outlook, WinWord I could sign
successfully, though they too were created in MS Office 2000 version.)

Sharad

 

[keepITcool]

you'll have to search for:

Macrosheets
Named Formulas using macro commands

and remove/replace these with "pure" vba.





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Sharad Naik wrote :

 

[Sharad Naik]

Well, I am using the "Template Wizard" in the workbook, and has hidden
macrosheet.
Can't remove it since I need the Template Wizard.

Thanks, for the tips

Sharad

 

[Myrna Larson]

As the message tells you, you CAN'T have XLM macro sheets in a signed project.
You'll have to get rid of the template wizard, or recreate your own wizard in
your VBA code.

 

[Sharad Naik]

Right,
I have to anyhow, do the code for integrating with access data base when I
will be getting rid of the template wizard.

Thanks.
Sharad