"MDubbelboer"
I entered the code as directed and clicked on the "X" and it closed. The
form should take on the screen until the program closes. Another words the
opening and closing of the program dictates the open and close of the form.
Also I don't have Object on the menu bar under View. I'm using 2003 Office.
Don't need the Msgbox since the buttons control only the printing.

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