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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
|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?
 
Has anyone resolved this issue?

I am currently working on a very old Excel file with the same issue as this and I have not been able to find any sort of resolution and would like to see if anyone can help me with this. Very frustrating and there is over 10 years worth of work on this one file that I would rather not try and update the macros to VBA by hand to get this thing to work with their Office 2007 upgrade.

Thanks for any help!!!!!


=?Utf-8?B?amdhc2Nvbg==?= said:
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
> news:[email protected]...
> |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?
>
>
>
Click to expand...
 
I find it really hard to believe that me and this other person are the only tow people who have ever come across this issue. Come on Excel nuts, rack your brains! AHAHAH
 
Wow... I have stumped the panel! Well next step... a Microsoft trouble ticket. OUCH!
 
Last edited:
Back
Top