I designed the workbook, and yes I do have code in the sheet module that
causes the pop up. When cell B2 is selected the userform pops up. If the user
wants to clear the entriies they have made they click a button and it
reformats the row to it's original state, however when it does the procedure
of reformatting the row since cell B2 is selected during the reformat it
causes the userform to pop up. I was just wondering if there was a way to
keep the userform from popping up during the reformat process or if maybe I
could have the close button, the red X, in the upper right corner of the
userform be utilized through code.
Thanks