How do I save a paswd protected .xlsm file containing old macros

[jgascon]

I have files containing macros created in previous versions of Excel that I
would like to save, password protected, in the new .xlsm format of Excel 07.
Excel 07 tells me that I have to remove password protection to protect these
files in the new, supposedly more secure, format.! How can I convert these
old VBA macros to make them acceptable to Excel 07 and save them with
password protection?

 

[Jim Rech]

I don't think there is a problem saving a protected XLSM file. The issue is
that when you open the file the macros are disabled and there is no option
to enable them. Is that your problem?

--
Jim
|I have files containing macros created in previous versions of Excel that I
| would like to save, password protected, in the new .xlsm format of Excel
07.
| Excel 07 tells me that I have to remove password protection to protect
these
| files in the new, supposedly more secure, format.! How can I convert these
| old VBA macros to make them acceptable to Excel 07 and save them with
| password protection?

 

[jgascon]

The password-protected file is now in .xls format. The macros are working
fine. If I try to save that file in .xlsm format I get the following erroe
message: "This workbook contains Excel 4.0 macros or Excel 5.0 modules. If
you like to password protect or restrict permissions to this document, you
need to remove these macros."

I do not want to remove these macros. How can I have a password-protected
..xlsm file that contains similar macros?