Great! Thanks for the extra info, it helps a lot.
Thanks
Doug

"Sam Wilson" wrote:

Your existing code must somewhere have an instruction to show the form,
something like

MyForm.show

What you need to do is put the lines

dim bCanc as boolean
bcanc = false

Once the password has been checked and is valid, put the line

bcanc = True

in your code. Then finally, after the line MyForm.Show you need to put

if bcanc = false then exit sub

Sam



"Doug" wrote:

I'm sorry, I'm a self taught rank amature at this. I don't understand your
suggestion. Can you give me some sample code please?
Thanks
Doug

"Sam Wilson" wrote:

Declare a public boolean variable and set it to false in your code before you
show the form.

Include a line setting the value of this variable to True when OK is clicked

back in the code that called the form, include a line to close the sheet if
the boolean variable is false.

"Doug" wrote:

I have a command button on a form that checks a password, if OK, it opens a
sheet. If I use the X on the top corner to close the form it opens the sheet
without checking the password. How do I close the sheet if the form is
exited. Thanks for the help.