Hi all
I want to check if an Excel file is already opened by someone else and if true display a message like 'File in use by ...name... please try again in afew minutes.'
At the moment I have buttons that open workbooks by macros which turn off screen updating and disable alerts, load the file, check for readonly and close the file if readonly is true with a message that file is in use.
I want to avoid the Excel user option of 'Open as readonly' but display who is using the file.
Any suggestions appreciated.