Results 1 to 7 of 7
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DISABLE CLOSE FORM ON CLICK 'x' (2000 sr 1)

    How to disable the close form with the click "X"...?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DISABLE CLOSE FORM ON CLICK 'x' (2000 sr 1)

    See Andrew Cronnolly's <post#=96240>post 96240</post#>. The code he posted goes into the module that belongs to the userform.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DISABLE CLOSE FORM ON CLICK 'x' (2000 sr 1)

    ... still, on button, is possible to eliminate the little line with the little point arround the botton when this is clicked?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DISABLE CLOSE FORM ON CLICK 'x' (2000 sr 1)

    The code in <post#=68870>post 68870</post#> can be used to hide the x button in the upper right corner of the userform.

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DISABLE CLOSE FORM ON CLICK 'x' (2000 sr 1)

    ok! very good code.
    But is allso possible to no permit to click on a "X" in a MsgBox and permit only the click on button "OK" of the msgbox?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DISABLE CLOSE FORM ON CLICK 'x' (2000 sr 1)

    The MsgBox function is a rather primitive Windows function. As far as I know, you can't control its close button. If it is really important to you, you could create a userform that looks like a MsgBox with the x button disabled or hidden. But it would be a lot of work.

  7. #7
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DISABLE CLOSE FORM ON CLICK 'x' (2000 sr 1)

    dont worry... i change my msgbox in a userform

Posting Permissions

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