Message Box according to user

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
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
 
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






.
Click to expand...
 
Back
Top