Thread: Need syntax for If user name in before save event
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mikeburg[_73_] mikeburg[_73_] is offline
external usenet poster
  
Posts: 1
Default Need syntax for If user name in before save event

I am trying to execute code in BeforeSave in ThisWorkbook when the
user's name is Mike. I tried the following but it does not work

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

I also tried the following but it does not work either:

User = Environ("UserName")
If User = "Mike" Then MsgBox User

I must not be using the correct syntax. Can someone help? Thanks a
lot. mikeburg


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

Reply With QuoteReply With Quote