Is there a way to disable or hide this button, I have a button on the userform to exit.
Is there a way to disable or hide this button, I have a button on the userform to exit.
Last edited by CobraLAD; 10-12-2007 at 06:59 AM.
refer to this thread, was an issue I had and which was answered very well
http://www.excelforum.com/showthread.php?t=615244
Hello CobraLAD,
Here is a simplier API approach to disabling the Close Box. To use the macro place it the UserForm_Activate event procedure.
Please Login or Register to view this content.
Adding the MacroPlease Login or Register to view this content.
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Right Click on any Sheet's tab
4. Left Click on View Code in the pop up menu
5. Press the keys ALT+I to activate the Insert menu
6. Press M to insert a Standard Module
7. Paste the code by pressing the keys CTRL+V
8. Make any custom changes you need to the macro
9. Save the Macro by pressing the keys CTRL+S
Sincerely,
Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks