Consulting

Results 1 to 8 of 8

Thread: Form Exit Button

  1. #1

    Form Exit Button

    I need to either disable or hide the form exit button.
    I am using VBA with Rockwell RSview32.
    Stuck on this issue for awhile. Very much appreciate any help.

    Thanks,

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,445
    Location
    Which form exit button are you referring to?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    Quote Originally Posted by Mike Vance
    I need to either disable or hide the form exit button.
    I am using VBA with Rockwell RSview32.
    Stuck on this issue for awhile. Very much appreciate any help.

    Thanks,

  4. #4
    The Default "X" next to the minimize and maximize buttons.

    Thanks,

  5. #5
    VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    On a userform Mike?
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  6. #6
    VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    This works on a userform in Excel...
    put it in the userform code module:
    [VBA]Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
    If CloseMode = 0 Then
    Cancel = True
    MsgBox "The X is disabled, please use the Close Command Button.", vbCritical
    End If

    End Sub[/VBA]
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  7. #7
    VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    Mike,
    I deleted your post in the other forum.....please do not post duplicate questions in multiple forums. It will only cause the good folks here to avoid your posts completely.....

    Please be considerate of the people who visit here to help others out. Surely you can see why it would be very annoying to go to the effort to find a solution for you only to find out that it had already been answered.....
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  8. #8
    Worked!

    Thank you,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •