How to close a userform close protected

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
 
K

Ken Macksey

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting language of a selected text in Office apps. 0
Word 2016 opening sooo slow 0
closing another file by code causes failure to run workbook activate event 2
How to close a userform in a forusers, close protected form? 1
How does one detect when an application is bieng close BY closing a window? 1
Close WorkBook 5
how to reshow userform after following a link 1
Errors Closing Userform 0

Top