If a file is locked for editing Excel allows the file to be opened as read only and saved as different file name. I want to avoid this and stop the file from being opened at all if it is locked for editing by another user.
The only way I know of is to password protect the file.
Go to File -> Save AS
On the Save box click Tools -> general options
Enter a password in the Password to open box. Re enter
Next time someone wants top open the document they will need to know the password and will not get the option to read only.
IF DONE CORRECTLY YOU WILL NOT GET ANY OPTION TO OPEN THE SPREADSHEET WITH OUT HAVING THE PASSWORD, THIS IS TRUE FOR ALL VERSIONS OF EXCEL. SEE IMAGE BELOW FOR REFERENCE