View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jgascon jgascon is offline
external usenet poster
 
Posts: 3
Default How do I save a paswd protected .xlsm file containing old macr

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?