• Home
 · 
• Miscellaneous
 · 
• Overlord

Overlord

I have seen alot of code disabling the "X" on the form to prevent uses closing the form, i.e. in the middle of data processing, this is a little "work around" i have been using...no magic..(o: or heavy API calls

Rate Overlord

• 1
• 2
• 3
• 4
• 5

(5(5 Vote))

Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
  If UnloadMode <> vbFormCode Then
    MsgBox "You gotta use the button"
    Cancel = 1
  Else
    Unload Form1
    Set Form1 = Nothing
  End If
End Sub