How to close a userform close protected

  • Thread starter Thread starter De Wilde Eddy
  • Start date Start date
D

De Wilde Eddy

If you want to prevent a Userform from closing when the user clicks th
x-button in the top right corner of the dialog.......
I tried the suggested Macro and it worked.
But now I cannot close it myself.
Is there a special way to do so because I need to return to m
worksheet
 
Hi

Try pressing the Control key(ctrl) and while holding it down, press the
Break Key.
Now put a command button on the userform and in the command button click sub
put Userform1.hide


HTH

Ken
 
Back
Top