who has the file open when I try to open it

[J. Emanuel]

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?

 

[Gary''s Student]

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

 

[J. Emanuel]

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]

Put the code in a standard module.

 

[J. Emanuel]

Are you able to send me a screen dunmp of how to do this please.
Thank you.

 

[Gary''s Student]

Macros are very easy to install and use:

1. ALT-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To use the macro from the normal Excel window:

1. ALT-F8
2. Select the macro
3. Touch Run



To remove the macro:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm