View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default How do I save a paswd protected .xlsm file containing old macros

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?