Had a workbook with macros developed in Excel 97. Loaded it into excel 2007. Works fine saved it in xlsm format. If I try to encrypt the file I get error message that basically says can't do it with old macros. I cannot find any reference on how to change macro sto be Excel2007 compatible. Is there one? So I saved the file in xls format. All is OK.

BUT, if I converted or rewrote the macros, I have read about another problem (and duplicated it). apparently you cannot open encrypted xlsm files with macros enabled. Can't find a way to override this. Found some reference to SP2. Thats what I have running. Found suggestions for registry change to disable virus scan of macros. Did not work.