AS87
11-30-2016, 09:58 AM
I have a userform that updates a sheet on a separate workbook. If someone else has this workbook open then any data the userform inputs is in read-only mode and tries to save as a copy. Is there any way to detect if a file is read only and display a suitable msgbox to try again in a few minutes?