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
Then once file opened I have the following commands under "THIS WORKBOOK" I have the following macros
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.
Bookmarks