disabling the 'cross' (one for VoG?)

  reddwarfcrew 20:58 16 Aug 04
Locked

I've got a little VB code that pops up a user form when the file is opened.

Is there anyway to disable the user from being able to click the 'cross' and thus close the user form without filling it in?

Thanks.

  reddwarfcrew 21:10 16 Aug 04

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)


If CloseMode <> 1 Then Cancel = 1


MsgBox ("You must complete the form!!")


End Sub

  reddwarfcrew 21:11 16 Aug 04

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)


If CloseMode <> 1 Then Cancel = 1


MsgBox ("You must complete the form!!")


End Sub

This thread is now locked and can not be replied to.

AMD Ryzen release date, specifications and features: Three CPUs from the Ryzen 7 range now…

1995-2015: How technology has changed the world in 20 years

Glassworks Barcelona shows how it captured the artistic imagination of Conor in A Monster Calls

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…