[mariaa33]

Went there and I guess you left.

[Rollin_Again]

Open the workbook and press ALT + F11 to open the VB editor. Then click INSERT >> USERFORM to add the form. When you insert the form you will see the properties window on the bottom left hand side. Scroll through the list for the property called "ShowModal" and set to False. Next add your button to the form from the control toolbox. Once the button is added you can change the default text by changing the caption property. After the button is added just double click it to bring up the button click event. This is where you add code to hide the form as well as the second part of your macro. I'm back on Meebo now if you need more help.

Regards,
Rollin

[mariaa33]

Got it! That works perfectly!! Thank you so much.

[OBP]

Thanks Rollin, that is one for slurpee and myself to remember.

[slurpee55]

I had no idea what Rollin was talking about...this is a fairly good explaination, but it would seem you already know this much....
http://kiwi.bridgeport.edu/cs440/cs4...almodeless.htm

[Rollin_Again]

Glad you got this sorted. Please mark this thread as solved and have a great weekend!!

Regards,
Rollin