VBA Code Macros

[Bradley H Callender]

How can I keep a user form up until it is used. For example i don't want the user to just close it please give me a macro code for that

 

[RoryA]

We need more information. What does the form do? Is there a button on it that has to be pressed?

 

[Bradley H Callender]

The form just has 3 buttons

open this workbook - which would ask for user info
Workbook instructions - a list of instructtions about the workbook
close this work - which would unload the form and close excel

i want the person not to click the "x" as soon as the workbook opens i want them use the buttons.

so is there a timer or loop i can put on that "x" (close)

 

[RoryA]

Are you talking about the X on the form, or the workbook or Excel window?

 

[YasserKhalil]

Try this code

Private Sub UserForm_QueryClose _
  (Cancel As Integer, CloseMode As Integer)
    If CloseMode = vbFormControlMenu Then
        MsgBox "Clicking the Close button does not work."
        Cancel = True
    End If
End Sub

 

[Bradley H Callender]

The x button on the window i want to prevent the user form clicking that

 

[RoryA]

If you show the form modally (the default) then they have to close the userform before they can do anything.

 

[Bradley H Callender]

Kindly walk me through I am a rookie

 

[RoryA]

Walk you through what exactly? What code do you have currently to show the form?

 

[Bradley H Callender]

I only have :

Private Sub Workbook_Open()
Workbookcontrol.Show
End Sub


Thats for auto open but i want to prevent the user form using the "X" to close the whole window