Try using

Me.hide

if the instruction is in the code associated with the userform.

--
Regards,
Tom Ogilvy

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/