Macro enabled Files in Office 2007

[gwoman]

If I have an XP Excel Spreadsheet and it contains macros and open it and save it in Excel 2007 format ... what would happen to my macros if it were saved as an .xlsx instead of an .xlsm format?
Would is disable my macros or would it strip them out all together?

Thanks much

gwoman

 

[TonyJollans]

If you try it, you will get a warning that they will be stripped right out - and they are.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[gwoman]

I hadn't tried it yet ... because I wasn't sure if it would throw a warning first!!!
Thanks so much!!!
Have a fabulous day!

gwoman