Hi,

Is there a way of a cell to say if an Excel workbook is in Read Only mode? I have some users that have missed that a workbook has opened in Read Only mode and have ended up putting time into a spreadsheet and lossing that work.

I know Excel lets you know if you try and save a read only file, but they've missed this too.

I was thinking of somthing that would give a text warning with conditional formating that that flash / highlight the cell.