Because several users have to read an excelfile(that is placed on a shared folder), it would be interessant to, by default open the workbook in the Read-Only Mode, and by clicking a commandbutton, place the file in normal mode.
In that way, while the file is read by different users, another user still can change the file.
Now it is mostly the case, once the file is opened, an other user can not change the file, and yet, the file is opened by users who are only consulting.
So, is it possible to always let the workbook open in Read-Only mode, and with a commandbutton put the workbook in Normal mode?
Thanks in advance,