View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Removing The Quit/X Button On An Userform

hi
not sure if you have remove it. it's to my understanding that it's sort of
built in to all forms.
but... you can disable it.
see this sites for ideas.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=164
http://j-walk.com/ss/Excel/tips/tip80.htm

regards
FSt1

"Hennie Neuhoff" wrote:

Hi All
Is it possible to remove the Quit/X button in the upper right corner of a
userform ?
Alternatively I've got a command button "Cancel" on the userform - if the
user do
click the Quit/ X button that the code for the cancel button applies?
I'm satisfied with the code for the cancel button, but I don't know what
steps should
be taken if the user click on the Quit/X button. [using 2003]

Thanks in advance

--
HJN