What happens when you step through the procedure? What line causes it to crash? Are all the bits of code usable on the Mac version? In other words, it has to be compatible with Excel 97. Some code that is used in XL 2000/2002/2003 will not work in XL 2004.

Unfortunately (?) I no longer have any version of Excel, so I can't help you investigate.