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?

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
"jgascon" wrote in message
...
|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?

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?

"Jim Rech" wrote:

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
"jgascon" wrote in message
...
|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?