Results 1 to 4 of 4

Thread: Hide Comment Red Mark but Show comment on hover

  1. #1
    Member
    Join Date
    May 2020
    Posts
    66
    Rep Power
    4

    Hide Comment Red Mark but Show comment on hover

    Whenever we add comment to a cell, a red mark is displayed in top right corner RED MARK.png
    And when we hover over the cell, it shows the comment box.

    I want to hide this red mark from the cell permanently, but still it should show comment box on mouse hover.

    I found only 3 option in the Excel setting, as shown in the attachment below, which do not fulfill my need.

    Is there any trick or VBA or anything else to solve this issue??
    Attached Images Attached Images

  2. #2
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,313
    Rep Power
    10
    I cant see those images. They are too small.

    Maybe use used https://imgur.com/upload
    Sometimes it is better for images at excelfox
    https://imgur.com/klEleuC
    https://imgur.com/T0Z7Ic0
    https://imgur.com/MYfUyRZ

    Maybe also upload a file to demo the problem also

    Alan
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
    Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!

  3. #3
    Member
    Join Date
    May 2020
    Posts
    66
    Rep Power
    4
    I've inserted the sample file here (commentbox.xlsx). Please find the attachment below.
    Attached Files Attached Files

  4. #4

Similar Threads

  1. Return a comment based on values in another cell
    By msiyab in forum Excel Help
    Replies: 5
    Last Post: 05-23-2015, 02:47 AM
  2. Replies: 2
    Last Post: 07-06-2013, 05:59 PM
  3. Did You Know :: Format Comment Box Using Shapes
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-16-2013, 10:50 PM
  4. Comment Formatting
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 0
    Last Post: 06-06-2013, 07:53 PM
  5. How to Get Comment by Vlookup Function :
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 0
    Last Post: 10-13-2011, 05:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •