Shared Workbook

[Abhijeet]

Hi
I want which user are open the file i want this info with the help of macro.I have track changes macro but in that macro if any save or delete the value then identify but i need who are use or open the file info in that

 

[Deepak]

As i understand you need something like this...

Private Sub Workbook_Open()

Dim user As Variant, struser As String
Application.ScreenUpdating = False
struser = Application.UserName
L1:
user = Application.InputBox("May i know your name Pls!!!") ', "Login User", , , , , , Type:=2)
Select Case user
    Case False
        ThisWorkbook.Close False
    Case ""
       MsgBox "You must click Cancel to exit.", 48, "Nothing."
       GoTo L1
End Select
End Sub

 

[Abhijeet]

No deepak this i donot want i want shared file which user are are open this file i want