Thanks Chip that works.
But now I'm having trouble hiding the form. The code I put in is:
Form.hide

but it tells me: Must close or hide topmost modal form first
I only have one form and the only code in it is the code you gave me.
I have a button on Sheet1 that has the code: Form.Show but i don't kno
what it wants me to close.

Any Suggestion?

Thank you
Morr

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