Is Workbook read-only because of file permission or because file is already opened?
 

Hi,

When someone opens my Excel workbook, I want to trap with VBA code
wether or not the file is read-only. Then, I want to do different
operations based on the cause of the read-only : file permissions are
read-only (or user does not have write permissions), or another user
already opened the file.

Is there a way to do such a distinction ?

Thank you very much in advance,


Alexis