There might be a multitude of reasons your worksheet or workbook is showing up as ‘ read-only’.
To be able to remove read-only from your sheet, it is important to understand why you see it in the first place. Possible Reasons your Sheet is ‘Read-only’
Possible Reasons your Sheet is ‘Read-only’.