Results 1 to 3 of 3

Thread: VBA yet again

  1. #1

    Thread Starter
    Fanatic Member coox's Avatar
    Join Date
    Oct 1999
    Posts
    550

    Post

    Any ideas how to turn off/disable the X (control box?) in the top right corner of a form in VBA? I know in VB you just turn of the control box property, but VBA doesn't seem to have it... (note, three .'s - happy???)

  2. #2
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,431

    Post

    Place the following in the form's QueryUnload event.
    Code:
        If UnloadMode = vbFormControlMenu Then
            Cancel = True
        End If
    ------------------
    Marty

  3. #3

    Thread Starter
    Fanatic Member coox's Avatar
    Join Date
    Oct 1999
    Posts
    550

    Post

    Hey! It works. Cool, thanks very much, Marty.

Posting Permissions

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



Click Here to Expand Forum to Full Width