How do I save a password protected .xlsm file containing old macro

[Brad]

I am trying to save a password protected .xlt file that was created in Office
95 and updated and worked on through the years (10+) to a Office 2007 format
..xlsm. The file contains a LARGE amount of Excel 4.0 macros and when I go to
save in the new file format I get a message on the screen that follows -

"The workbook contains Excel 4.0 or Excel 5.0 modules. If you would like to
password protect or restrict permissions to this document, you need to remove
these macros." I have read artical KB927150 on the Microsfot support site
and it suggests that SP2 resolves the issue, but ALL clients have SP2 for
Office 2007 installed.

But of course the issue is that the client does not want to remove these
macros, nor do they want to recreate what they have. I have searched high
and low and I have not seen an answer to this question out on the internet,
but I have seen the same problem for others. Any thoughts or suggestions on
how to address this and get the file moved into Office 2007 format?

 

[Dennis Chou]

have you tried copying the macros into word, changing the xls file into a
xlsm format and then pasting the macros back into the vba editor?

 

[Brad]

Tried it with no luck. Thanks for the input. Any other ideas out there?