You can save the file in .XLS format (97/2003 compatible) and the macro will still be contained within it, so your co-worker should be able to use the file.

Hope this helps.

Pete