Hammer1947 Wrote:
Thanks Leith,
I don't want to have to Alt F8 to display the form. The form needs t
be
loaded and visible at all times while the excel program is running. Th
only
thing I was concerned about was the close "X". If I accidentally clic
the
close "X" the form goes away and I can't get it back. Ideally would b
to get
rid of the "X" button since I never want to close it during the runnin
of
the program. This form has buttons on it that are always used durin
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 th
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 th
UserForm.
--
MDubbelboe
-----------------------------------------------------------------------
MDubbelboer's Profile:
http://www.excelforum.com/member.php...fo&userid=3633
View this thread:
http://www.excelforum.com/showthread.php?threadid=56233