PDA

Click to See Complete Forum and Search --> : VBA yet again


coox
Nov 8th, 1999, 09:51 PM
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???)

MartinLiss
Nov 8th, 1999, 10:00 PM
Place the following in the form's QueryUnload event.
If UnloadMode = vbFormControlMenu Then
Cancel = True
End If


------------------
Marty

coox
Nov 8th, 1999, 10:05 PM
Hey! It works. Cool, thanks very much, Marty.