View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Brad Brad is offline
external usenet poster
 
Posts: 846
Default How do I save a password protected .xlsm file containing old m

Tried it with no luck. Thanks for the input. Any other ideas out there?

"Dennis Chou" wrote:

have you tried copying the macros into word, changing the xls file into a
xlsm format and then pasting the macros back into the vba editor?

"Brad" wrote in message
...
I am trying to save a password protected .xlt file that was created in
Office
95 and updated and worked on through the years (10+) to a Office 2007
format
.xlsm. The file contains a LARGE amount of Excel 4.0 macros and when I go
to
save in the new file format I get a message on the screen that follows -

"The workbook contains Excel 4.0 or Excel 5.0 modules. If you would like
to
password protect or restrict permissions to this document, you need to
remove
these macros." I have read artical KB927150 on the Microsfot support site
and it suggests that SP2 resolves the issue, but ALL clients have SP2 for
Office 2007 installed.

But of course the issue is that the client does not want to remove these
macros, nor do they want to recreate what they have. I have searched high
and low and I have not seen an answer to this question out on the
internet,
but I have seen the same problem for others. Any thoughts or suggestions
on
how to address this and get the file moved into Office 2007 format?