morry wrote in message ...
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 know
what it wants me to close.

Any Suggestion?

Thank you
Morry


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

Try using the command Unload Userform1 instead of Form.hide

HTH
Charles