Hi

I have a workbook on sharepoint that im trying to get it to come up read only of more that 1 person has it open.

At present I have the following macro in a seperate workbook to open the file


Please Login or Register  to view this content.
Then once file opened I have the following commands under "THIS WORKBOOK" I have the following macros

Please Login or Register  to view this content.
Whats happening is when I open the workbook and no one else is it it coming up with the message box of "Warning - This Workbook is Currently Read-Only" of which is false.
Then when someone is in it it comes up as read only correctly and says whos amending and do I want to open a read only copy of which I select and it then comes up with an error.

Any ideas how I can get it to come up read only with a warning if someone else is in the file as read/write.