Environ("NWUSERNAME")

returns nothing for me - is that what you really intended?

--
Regards,
Tom Ogilvy


"colofnature" wrote:


Private Sub Workbook_BeforeClose(Cancel As Boolean)

[a1].Value = Now
[a2].Value = Environ("NWUSERNAME")

End Sub


Change a1 & b1 to whichever cells you want the info in.
Col


--
colofnature
------------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356
View this thread: http://www.excelforum.com/showthread...hreadid=544777