| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accidentally close user form_how to open
Success! Got the code to work thanks, M
gary "MDubbelboer" wrote: Hammer1947 Wrote: Thanks Leith, I don't want to have to Alt F8 to display the form. The form needs to be loaded and visible at all times while the excel program is running. The only thing I was concerned about was the close "X". If I accidentally click the close "X" the form goes away and I can't get it back. Ideally would be to get rid of the "X" button since I never want to close it during the running of the program. This form has buttons on it that are always used during the program. gary from: http://www.contextures.com/xlUserForm01.html To prevent users from closing the form by clicking the X button: 1. Right-click on an empty part of the UserForm 2. Choose View | Code 3. Scroll to the bottom of the existing code, and enter the following code: Private Sub UserForm_QueryClose(Cancel As Integer, _ CloseMode As Integer) If CloseMode = vbFormControlMenu Then Cancel = True MsgBox "Please use the button!" End If End Sub 4. On the Menu bar, choose View | Object, to return to the UserForm. -- MDubbelboer ------------------------------------------------------------------------ MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330 View this thread: http://www.excelforum.com/showthread...hreadid=562333 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Close User Form | Excel Discussion (Misc queries) | |||
| How was user able to (accidentally) change an unlocked cell to loc | Excel Worksheet Functions | |||
| Macro to Prompt User to Close After Saving | Excel Discussion (Misc queries) | |||
| close user form | Excel Programming | |||
| Open Only the User Form ... or Close Everything ! | Excel Programming | |||
Hybrid Mode
