LinkBack URL
About LinkBacks
Hi there
Does anyone have a code for removing the X button on a userform?
Cheers
Dan
Hi there
Does anyone have a code for removing the X button on a userform?
Cheers
Dan
Hi DanzaNZ,
Though I haven't got the exact link, I do know the following originated from OzGrid:
Just include the above code in the relevant form.
Please Login or Register to view this content.
Make sure you also have code to close the form and the desired point as the user will no longer be manually able to do it.
HTH
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
This doesn't remove the X button, but it does prevent it from closing the userform. It's still there but does nothing.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks AlphaFrogOriginally Posted by AlphaFrog
This doesn't remove the X button, but it does prevent it from closing the userform. It's still there but does nothing.
Please Login or Register to view this content.
Does this code still enable a command button to be coded to close the form?
My command button is set to close the entire workbook.
Cheers
Dan
Yes.
The code only disables the X button. You could still close the userform by any other method.
Great!
Solved, thank you AlphaFrog!
Cheers
Dan
FYI - For those who are interested in actually removing the Close X from a window or UserForm, here is the code.
BE CAREFUL WITH THIS CODE
It removes the Close X from the Active Window. To use with a UserForm add a call to the macro RemoveCloseX in the UserForm_Activate() event module
Remove the Close X on a UserForm
Windows 7 and LaterPlease Login or Register to view this content.
This code is compatabile with Windows 7 and later. Add a new VBA module to your workbook and paste the code below into it.
Windows 95 through XPPlease Login or Register to view this content.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks