PDA

View Full Version : Hide Comment Red Mark but Show comment on hover



Anshu
08-27-2020, 11:56 AM
Whenever we add comment to a cell, a red mark is displayed in top right corner 3374
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??

DocAElstein
08-28-2020, 03:04 PM
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

Anshu
08-28-2020, 07:10 PM
I've inserted the sample file here (commentbox.xlsx). Please find the attachment below.

Logit
08-28-2020, 09:09 PM
.
https://www.mrexcel.com/board/threads/vba-to-remove-comment-indicator.822080/

https://www.wmlcloud.com/microsoft-office/excel/remove-comment-indicators-red-triangles-with-vba/

https://www.excelforum.com/excel-general/1139246-how-to-eliminate-the-red-mark-on-the-cell-with-comment-indicator.html