Following is a quick summary of my set up followed by the problem I’m seeing.
When a user opens spreadsheet1 it automatically opens spreadsheet2 in read-only mode using Auto_Open.
Spreadsheet1 contains several cells where users enter comments. Once the comments are entered there is a...