Can't save with another user using as read only

[MarcLP]

Hi!
I have 3 .xlsx files with this problem.
A user open the file to edit.
A Second user open it as read only.
The first user can not save the file.
There is a msg that "another person is working on it... Try it later".
Any ideas?
Tks

 

[Skyybot]

This may work. Place this code in Workbook and save as .xlsm

Private Sub Workbook_Open()
If ThisWorkbook.ReadOnly = True Then
    MsgBox "This Workbook is being used by another person. Please try again later.", vbInformation, "Unavailable"
    ThisWorkbook.Close
End If
End Sub

 

[MarcLP]

This may work. Place this code in Workbook and save as .xlsm

Private Sub Workbook_Open()
If ThisWorkbook.ReadOnly = True Then
    MsgBox "This Workbook is being used by another person. Please try again later.", vbInformation, "Unavailable"
    ThisWorkbook.Close
End If
End Sub

Thanks for your reply, but I wanna let people open it as ready only. It Just can't stop the saving capacity of the user not in read only.

 

[Skyybot]

Do you and your Users use Office 365?

 

[MarcLP]

Do you and your Users use Office 365?

Yes! It's in a company.

 

[Skyybot]

These may help out with your issue.

Share your Excel workbook with others - Microsoft Support

Learn how to use the new simplified sharing feature in Excel. Now it's easier to share your spreadsheet with others on SharePoint, OneDrive, or OneDrive for Business.

support.microsoft.com

Collaborate on Excel workbooks at the same time with co-authoring - Microsoft Support

You can open an Excel workbook and collaborate with others at the same time using co-authoring. This article will explain how.

support.microsoft.com