Looking for a macro to lock all cells ONLY when doc is read-only

The above assumes no sheets to be protected in original state and all cells have default Locked status (and Macros are being enabled)

Can you outline why you want to do this ? It could be that a "password to modify" would suffice ?

If an end-user opts to make changes having been notified it's read only I suspect you have "bigger fish to fry".

If needed you could generate an additional MsgBox that appears upon Open (in Read Only mode) that reiterates to end-user the fact that no changes made can be saved.

If you really want to go down this route you need to also consider the possibility that Macros might not be enabled in the first instance which would make any subsequent coding moot.

In reality you either need to:

a) rely on end user intelligence in first instance

or

b) code the file such that when saved/closed in read-write mode it is "locked down" and is only "unlocked" if Macros are Enabled and the file is not in Read Only state
(all by virtue of the Open event)

Since I had few cells that should be locked for all users, I used perboeggild's code, with a little addition of mine,

Check it out

Please Login or Register  to view this content.

Thank you all ~ SOLVED