Mac issue with macro recording user login & date (run time error '

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Environ method not available on Macs. Would Application.UserName in
place of Environ("UserName") do?
 
Thanks!! One more question -- how do I change the 'Application.Username'
value?

Thanks,

Robert
 
Did you try setting the property?

Application.Username = "whatever"

"Linking to specific cells in pivot table"
 
Robert,
Application.Username is Read/Write.
However, it is an Office wide property, so Word, Access etc will pick up the
change.

NickHK

"Linking to specific cells in pivot table"
 
If you are looking to change it on individual computers, look in Tools,
Options and I believe General tab.
 
Back
Top