Maybe the recipient didn't allow macros to run when they opened your file.

And you should save as a normal workbook (*.xls).

xl2007 will be able to open it.

JanB wrote:

I have only 2003 and will help a friend of mine. He has only 2007. When I
write a simple macro in 2003, it will not work in 2007

What format should I save the file

( the macro is simple as Copy one row of data and paste it in another sheet)

Hope these genuine group will find a solution.

--

Dave Peterson