disabling the 'cross' (one for VoG?)

  reddwarfcrew 20:58 16 Aug 2004
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 2004

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 2004

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.

Elsewhere on IDG sites

Best Amazon Echo: What’s the best Alexa speaker?

Kano Computer Kit Complete review: A fun DIY 'laptop' that teaches kids to code

Best pro photo editors for Mac 2018

TV & streaming : comment regarder les Jeux olympiques d’hiver 2018 ?