Disable sub

[Noz2k]

I've created a sub which prompts the user for a password when they try to change a specific combobox, however I want to disable this sub once the password has been enterered correctly. So that the user doesn't keep getting prompted for a password. And then I'd reenable the sub when on userform initialize.

Any Idea how I can do this?

 

[craig.penny]

Maybe try dimensioning a boolean variable in the calling sub and set it to true once the password has been entered correctly. In the second line of your sub you can text the variable and exit if it's true. I'm assuming this sub may be called from multiple places, which is why I'm suggesting you check the variable after, instead of before, you call it.

Sub Example(Optional ByRef bFlag as Boolean)
 
If bFlag Then Exit Sub
 
...
 
 
End Sub