If you save the file in default xlsx format, it strips out the VBA parts of
the file before saving. You need to save it as 'macro enabled', or xlsm
format.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"alistew" wrote in message
...
I am using Office 2007, and every time I open an Excel file created in the
2003 format it removes the macros and code I have created in that file.

Is there a way i can get round this?