I have the following function procedu


Function read_only_status()
read_only_status = activeworkbook.ReadOnly
End Function


This returns a value of "true" when the workbook is read-only and "false"
when it is not. This works fine when the function is first entered into a
cell. However, since the function doesn't refer to a cell, if the workbook
status is changed (from/to read-only) the function is not called and the
value is not updated.

Any suggestions as to how I can get the function called when the read-write
status changes or some other work around?

Thank you.