Not sure what I'm doing wrong, but I can't get it to work. This is what I'm doing:
record macro-->edit macro-->paste the code from above-->stop recording-->save-->run macro
It gives me an error if I leave in the workbook_open part, so here is the code I'm trying to use
Sub Macro18()
'
' Macro18 Macro
'outrow = Sheets("Log").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
' Sheets("Log").Cells(outrow, 1).Value = Application.UserName
'Sheets("log").Cells(outrow, 2).Value = Environ("username")
'Sheets("Log").Cells(outrow, 3).Value = Date
End Sub
any ideas on why it won't work?
I can't put my workbook in this thread but I'll PM it to anybody if they think they can figure it out.
Bookmarks