Hi,

I want to create an activity log sheet. Being a begginer in VBA
programming I just could't figure out what to change in the below code
to save the info.

More precisely, when someone opens the workbook the info appears in
the uLog sheet. But then I want it to be saved and then, record on the
following line when the person closes the workbook. The procedure
should repeat itself when the wb is open and then closed.


____
Private Sub Workbook_Open()

Users = ActiveWorkbook.UserStatus

With Sheets("uLog")
For Row = 1 To UBound(Users, 1)
.Cells(Row, 1) = Users(Row, 1)
.Cells(Row, 2) = Users(Row, 2)
Next
End With

End Sub
_____


Thank you in advance
Gabriel