 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / December 2007Disable the Close button on a Userform
how do i disable the close button on my userform? or can i just remove it? and when the user clicks cancel... is there a way to direct the user back to sheet1 ? Cheers -- Hi, Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) If CloseMode = vbFormControlMenu Then ' make user do what you want" Cancel = True End If End Sub HTH where do i put this code?  Signature> Hi, > [quoted text clipped - 7 lines] > > HTH > where do i put this code? > -- [quoted text clipped - 12 lines] > > - Show quoted text - Hi Double click your form and paste it in (the code module behind the form) regards Paul it doesn't work pls help further Signature> > where do i put this code? > > -- [quoted text clipped - 18 lines] > regards > Paul What exactly do you mean by "it doesn't work"? Maybe you need to add a Command Button with the following code: Private Sub CommandButton1_Click() Sheet1.Activate Unload Me End Sub Open your form, hit F7 and copy code ... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.