Apr 12 2019 04:22 PM
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 to hover over parts of the document and see the comments individually.
Apr 13 2019 03:09 AM
@Kellykr , IMHO, comments are visible on protected sheet same way as on unprotected one.
Apr 13 2019 06:23 AM
When I protect the sheet in Excel, then I hover over the cell with the inserted (and the little red triangle in the upper right corner), the comment does not appear. @Sergei Baklan
Apr 13 2019 06:33 AM
@Kellykr , here is the cell with the comment on protected sheet
And here I hover the mouse over the cell
Apr 13 2019 06:40 AM
Apr 13 2019 06:47 AM
@Kellykr , not sure, I'm on 2016, but my guess on 2013 it shall be the same. You may check attached file, password 1234, comment is in F52. That's just Protect Sheet as you said.
Apr 13 2019 07:12 AM
@Sergei Baklan is it possible to send my document to you to see if you can see why it does not work for me? if I attached it correctly, the password is 1234 and the comments are in the cells with the red circles.
Apr 13 2019 07:38 AM
@Kellykr , the sheet in the file you attached is unprotected, I may edit it. Please protect to check again.
Apr 13 2019 07:48 AM
Apr 13 2019 08:19 AM
@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.
Apr 13 2019 08:33 AM
Apr 13 2019 08:46 AM
@Kellykr , so far so good, you are welcome