firemandave
New Member
- Joined
- Feb 16, 2016
- Messages
- 10
One of my workbooks at work has starting doing a strange thing, right after I protected one of the spreadsheets.
I made it so that only a selection of cells could be edited, with the remaining unable to be even selected.
When I copy and paste an identicle region of cells in another spreadsheet (which contains a number of comments) and then paste, all the comments are "shrunk". That is, you can still see that there is a comment there, however when you hover over them all you see is vertical line.
You edit the comment and then drag the handles to resize the comment (obviously not ideal every time I copy and paste). I know it has something to do with the protection, as it worked for years prior.
In the Protect Sheet window I have selected: Select unlocked cells, Insert Columns, Edit objects, and Edit scenarios.
And ideas? Thanks in advance :D
I made it so that only a selection of cells could be edited, with the remaining unable to be even selected.
When I copy and paste an identicle region of cells in another spreadsheet (which contains a number of comments) and then paste, all the comments are "shrunk". That is, you can still see that there is a comment there, however when you hover over them all you see is vertical line.
You edit the comment and then drag the handles to resize the comment (obviously not ideal every time I copy and paste). I know it has something to do with the protection, as it worked for years prior.
In the Protect Sheet window I have selected: Select unlocked cells, Insert Columns, Edit objects, and Edit scenarios.
And ideas? Thanks in advance :D
Which version of Excel are you using?
