Put the code in a standard module.
--
Gary''s Student - gsnu200843


"J. Emanuel" wrote:

Hello Gary"s Student, can explain where this code should go, as I need to
ensure that all my other colleaguess have the same setting?

"Gary''s Student" wrote:

try this macro:

Sub WhoIsIt()
With ActiveWorkbook
If .WriteReserved = True Then
MsgBox "Please contact " & .WriteReservedBy & Chr(13) & _
" if you need to insert data in this workbook."
End If
End With
End Sub

--
Gary''s Student - gsnu200843


"J. Emanuel" wrote:

In the old version of Microsoft 2003 you were able to see who had a file open
that you wanted to open. Thus asking the right person to come out of the
file once they had finished their work

Now in the 2007 version of excel we can not see this feature within the
pop-up windeow that tells you someone has it open. There is a team of us
that use specific files, with one of the colleagues being based in Mumbai.
So when the file is open you are unable to tell who has the file open.

Is there a solution to correct this?