Does something like this work:

Option Explicit

Sub OpenMyForm()
If Not Range("A1") = "Don't Open" Then
UserForm1.Show
End If
End Sub


With the userform code:

Private Sub UserForm_Initialize()

Range("A1") = "Don't Open"

End Sub


"Greg B" wrote:

No, I am asking is it possible to cancel a userform that starts on loading a
form for the first time and is it possilble to make a macro to stop this
userform from loading again.