Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can i know the last user who open the workbook
Hi,cas i share my wrokbook with a group , i want wirte a macro code to know
the last user &time who open the workbook ? any help will be appreciated -- Regards, Sebation.G |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can i know the last user who open the workbook
Put:
Private Sub Workbook_BeforeClose(Cancel As Boolean) Set r = Sheets("Sheet1").Range("Z100") r.Value = Environ("UserName") r.Offset(0, 1).Value = Now End Sub in the ThisWorkbook code area. The previous user's name and date/time will be recorded in Z100 and Z101. -- Gary''s Student - gsnu200721 "Sebation.G" wrote: Hi,cas i share my wrokbook with a group , i want wirte a macro code to know the last user &time who open the workbook ? any help will be appreciated -- Regards, Sebation.G |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can i know the last user who open the workbook
thanks,
it does work well -- Regards, Sebation.G "Gary''s Student" ... Put: Private Sub Workbook_BeforeClose(Cancel As Boolean) Set r = Sheets("Sheet1").Range("Z100") r.Value = Environ("UserName") r.Offset(0, 1).Value = Now End Sub in the ThisWorkbook code area. The previous user's name and date/time will be recorded in Z100 and Z101. -- Gary''s Student - gsnu200721 "Sebation.G" wrote: Hi,cas i share my wrokbook with a group , i want wirte a macro code to know the last user &time who open the workbook ? any help will be appreciated -- Regards, Sebation.G |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying the user that has a workbook open? | Excel Programming | |||
Open workbook in user-defined folder | Excel Programming | |||
How to create a URL and when user clicks it to open a Excel workbook | Excel Programming | |||
Check For Open Workbook by another User | Excel Programming | |||
Excel not warning if another user has the workbook open | Excel Programming |