Nolin,

I too am having trouble getting code written in XL 2002 to work whe
run on XL 2000. One issue I noticed, however, is that if the user o
XL2000 has kept their XL updated with service packs, then the macro
work. I don't know what service pack fixs the problem though.

Another suggestion: Trap the line in your code that is causing th
hangup and post the error on these pages. I do this by inserting:

msgbox ("A")
1st line of code
msgbox("B")
2ndline of text

etc. When the macro runs on XL2000 you can find which line causes th
problem


I have another post out there where I ask the similar question and I a
asking for some feedback. Use search option on this forum fo
username: "jasonsweeney" and see my related post

--
Message posted from http://www.ExcelForum.com