What I mean is that anything within the If statement does not execute.

Yes, I am sure that UserName is mike, because I can put the following
in the before save event & the message box displays the word Mike

Msgbox Environ("UserName")

Also, thanks for your comment about the log on name. I didn't realize
that. What would be the code to MsgBox the user name in Tools,
Options, General?

However, more importantly, how can I get the If statement to work?

If Environ("UserName") = "Mike" then Msgbox Environ("UserName")

Thanks for your replys. mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=508723