| | |
| |||||||
| Forums | Register | Groups | Awards | Arcade | Pets | T-Bucks / T-Store | Invite Your Friends | Blogs | Mark Forums Read |
| Microsoft Applications Discussions about Windows and other MS Products such as Office |
 |
| | LinkBack | Thread Tools |
06-16-2004, 03:44
| #1 (permalink) |
| Civilians |  How to close a userform close protected If you want to prevent a Userform from closing when the user clicks the 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 my worksheet? --- Message posted from http://www.ExcelForum.com/ |
     |
| Trackpads Information |
| |
|
06-16-2004, 03:46
| #2 (permalink) |
| Civilians | Re: How to close a userform close protected 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.692 / Virus Database: 453 - Release Date: 28/05/2004 |
| |
|
| Bookmarks |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Close combat drills prepare recruits for close calls in battle, Dec 1 | Master_Blastard | DefenseLink | 0 | 12-01-2006 19:02 |
| Protected PPT files causing VB SaveAs and Close errors... | Paul | Microsoft Applications | 3 | 08-13-2005 04:00 |
| userform - close | Siegfried | Microsoft Applications | 3 | 04-24-2005 16:00 |
| how can I close a UserForm using a shortcut key ? | Rob | Microsoft Applications | 2 | 11-28-2004 10:00 |
| Close look at the MGS! | Hannibal | Army | 31 | 06-14-2004 21:05 |
 |  |  |
