Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
remove close button
easier is to use the queryclose event to control the closing of the form:
Private Sub UserForm_QueryClose(cancel As Integer, closemode As Integer) here are the possible values for the closemode argument vbFormControlMenu 0 The user has chosen the Close command from the Control menu on the UserForm. vbFormCode 1 The Unload statement is invoked from code. vbAppWindows 2 The current Windows operating environment session is ending. vbAppTaskManager 3 The Windows Task Manager is closing the application. From the closemode argument, you can test why the form is being closed - if you disagree, you can set Cancel = True and display a warning message - for example if closemode = vbFormControlMenu. If it is one of the other options, you might perform some cleanup and then let the form close. -- Regards, Tom Ogilvy "Josh Ashcraft" wrote in message ... how do i remove the close button (X) from the top of a userform? Thanks, Josh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
close button does not close | Excel Discussion (Misc queries) | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel | |||
remove close button | Excel Programming | |||
remove close button | Excel Programming |