Message Box according to user

[Mike]

Good morning,
I have done my security wizard and everything and have
differant users and such. I would like to set up a macro
message box to pop up only when 1 user logs in, and a
differant one for when another user logs in. Is this
possible?? Any help is greatly appreciated. Thank you
for your time.

Respectfully,
Mike

 

[Evan]

Now sure of what vesrion you are using but I would imagine dead easy!

Rather than macro I would use code - somehting on the lines of:

Select Case CurrentUser()

Case "Bill": Msgbox "Morning Bill"
Case "Mike": Msgbox "Afternoon Mike"
Case else: msgbox "Who are you?"

End Select

 

[MIke]

Thanks works great!

-----Original Message-----
Now sure of what vesrion you are using but I would imagine dead easy!

Rather than macro I would use code - somehting on the lines of:

Select Case CurrentUser()

Case "Bill": Msgbox "Morning Bill"
Case "Mike": Msgbox "Afternoon Mike"
Case else: msgbox "Who are you?"

End Select






.