Hi,

Based on feedback from a post I entered early this week, I used the code
below (entered in the "General Declarations" section of the "This Workbook"
sheet) to record the user ID and date of when a spreadsheet is opened. The
issue is the person using this spreadsheet has a Mac and said they are
getting the following error when opening the spreadsheet: "run time error
'5'".

He said that the error apparently is stopping the userid from being recorded
(the date is populating OK). Any help on how to get around this is
appreciated! - Robert

Private Sub Workbook_Open()

Dim rng As Range

Set rng = Sheets("Proj.Mngt.").Range("I45").End(xlUp).Offset (1, 0)

rng.Value = Now()
rng.Offset(0, 1) = Environ("UserName")

End Sub