Can This Be Done !?!

[liammoohan]

I currently have a sheet that multiple users will use and at times as was the case on friday two people had accessed the sheet at the same time.

Is there any VB code that can display a msgbox when the sheet is opened read only to prompt the 2nd User as when the sheet is used it needs to save the data the user enters and someone using read only will lose all the data.

Can anyone Help?

 

[Yard]

The user must know they've accessed the file read-only though, when they either bypassed the password box, or bypassed the Read-Only recommended message, or bypassed the "File is in use with another user" message??

If they've missed that, then maybe something like

Private Sub Workbook_Open()
If Me.ReadOnly Then
    MsgBox "This file is open as read-only...you will not be able to save your changes,", vbExclamation + vbOKOnly, "Oi!"
End If
End Sub

placed in the ThisWorkbook module of the file.