Remove comments showing up on mouse-over?

**Marco-Kun** · 04-18-2009, 05:36 AM

Hmm maybe the title is a little vague .. but it will work;

In the example added a code is running to show the comments (pictures) when the cell is selected. This way you don't have to mouse-over to show the comment, you just use your arrow keys.. Is there a way to not show comments on mouse-over? I only want them to show while the cell is selected, using the VBA code. Because now you can show 2 comments while a cell is selected, and you put your cursor on another cell.

Marco

**Andy Pope** · 04-18-2009, 06:43 AM

Add this code to the Thisworkbook module.

Please Login or Register  to view this content.

And this revised SelectionChange event code to the sheet.

Please Login or Register  to view this content.

This will display the comment when a valid cell in column A is selected. And hide any previous comment

**Marco-Kun** · 04-18-2009, 07:05 AM

Andy .. you are awesome

Thank you very much ^^

**ddouville** · 08-22-2014, 10:23 AM

could you please teach me step by step how to clear the VBA codes so that i can clear the comments in my worksheet?
i cannot seem to get rid of the comments

can you help!??/
see attached as my test example - hover over first column and the comments box appears