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 macros

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?