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 :

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