Forum Discussion

Kellykr's avatar
Kellykr
Copper Contributor
Apr 12, 2019

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 ...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 13, 2019

Kellykr , IMHO, comments are visible on protected sheet same way as on unprotected one.

  • Kellykr's avatar
    Kellykr
    Copper Contributor
    Apr 13, 2019

    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 

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Apr 13, 2019

      Kellykr , here is the cell with the comment on protected sheet

      And here I hover the mouse over the cell

      • Kellykr's avatar
        Kellykr
        Copper Contributor
        Apr 13, 2019
        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.

Resources