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

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

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
"keepITcool" wrote in message
ft.com...

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

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.


On Wed, 10 Nov 2004 19:30:24 +0530, "Sharad Naik"
wrote:

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
"keepITcool" wrote in message
oft.com...

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

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

"Myrna Larson" wrote in message
...
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.


On Wed, 10 Nov 2004 19:30:24 +0530, "Sharad Naik"

wrote:

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
"keepITcool" wrote in message
soft.com...

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