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