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 ...
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. SergeiBaklan
Kellykr , here is the cell with the comment on protected sheet
And here I hover the mouse over the cell
- Maybe I am selecting something incorrectly. But if I go to the toolbar and select 'Protect Sheet', leave the default selections checked, set my password and click OK, the hover function does not show the comments. Do I need to select certain parts of the document prior to protecting the page? I am using Excel 2013.
BTW, I appreciate your attempt to help me out. Thank you.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.
SergeiBaklan 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.