Forum Discussion
viewing comments with hover in a protected sheet
I want to protect a worksheet in Excel 2013 and still have the mouseover or hover over comments visible. I don't want others to be able to change anything on the document, but I want them to be able ...
Kellykr , that is since you have shapes on the top of cells with the comments. If you remove them / move on another place, comments will be visible in protected sheet. Actually don't know how to fix with shapes, if only unlock them - but when users will be able to edit/remove shapes.
If you try with other alternatives, like formatted numbers within the cells - that works. If it will be something in mind with shapes I'll let you know, right know has no solution.
Kellykr , so far so good, you are welcome
- Thanks for the help. Changing the color of the cell and putting a number in there, works perfect. I was overthinking the form from the beginning.
Thanks again!!