Hi Barb

If you save the file as xlsx in 2007 all the code is gone
Save the file as xlsm or xlsb in 2007

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Barb Reinhardt" wrote in message
...
I don't have 2007 installed anywhere, but we're having problems with
workbooks that I modified in Excel 2003 to include a lot of macros. Now
(5-6 months after release), I'm being told by some users that the workbooks
have no macros. One was sent to me and all of the worksheet code names had
been removed as well. Can someone tell me what happens if an Excel 2003
workbook with macros and modified worksheet codenames is saved as an Excel
2007 .xlsx file and then reopened in Excel 2003 (if it's possible). I'm
wondering if that's what's been happening with these files. I don't believe
that 2007 has been deployed enterprise wide, but I'm beginning to wonder if
some have it already.

Thanks,
Barb Reinhardt