Code to open file read only mode in network

Hello everybody!
I have an excel file in a folder shared in a network.
I need the file to be opened in read only mode by everybody except one or 2 particular users.
As logic, it goes something like this:

If User <>”Jane Doe” or User <>”John Doe”
Open in read only mode
Else
Open in read/write mode
Endif

But I don’t know how to code. Can anybody, please help?

Hi !

Without any code just with a password at workbook level ! As people without the password can only open in read only mode …

You could also protect the workbook, preventing other users from making changes. Another approach would be preventing other users from being able to save the workbook, e.g.

Please Login or Register  to view this content.

Thank you! Both solution worked