Hi,

Thank you both for your help. I don't seem to be able to get my head around
this. I finally solved the issue by using a form label and assigning a value
to it when I called the password form. I then used the label value as my
"Traffic Cop" to route back to the appropriate routine.
--
Thanks for your help.
Karen53


"Karen53" wrote:

Hi,

I'm not sure I can do this. I've been unable to figure out how, but I have
created a password form. I need to use this form to unlock specific cells
and run code depending on the password being correct. I am successful if
there is only one routine the password form is unlocking. I need a value of
true or false to be pulled into multiple routines. I'm thinking a function
but I can't figure out how to achieve it. I'm hung up on where do I go with
cmdOK?

Function GoodPassword(GoodPswd) As Boolean

Dim HasPswd As String

frmPassword.Show

HasPswd = frmPassword.txtGetPswd

Unload frmPassword

GoodPswd = False

If HasPswd = "" Then
GoodPswd = False
Else
If HasPswd = MyPassword Then
GoodPswd = True
End If
End If

End Function


--
Thanks for your help.
Karen53