Disable comments on mouse hover

[zorrozac]

Hi,

I have a number of items in column A and each has a comment field.

It there a command to disable the comment text from showing ( i do not want to delete the comment ) as the mouse hovers over the cell.

Similarly, is there an opposite command to re-enable the comments to
be seen when the mouse hovers over the cell.

Thank you in advance.

Best regards,

Zorrozac

[mikerickson]

In the Excel>Preferences (called Excel>Options in some versions), General set Comments-None.

[zorrozac]

Hi Mike,

Thank you very much for your express response.

Following your instructions,
I recorded a macro to obtain the required VBA code.

Using VBA, to disable comments in all cells, I used:

Application.DisplayCommentIndicator = 0

Using VBA, to re-enable comments in all cells, I used:

Application.DisplayCommentIndicator = xlCommentIndicatorOnly

The great thing about this process, is that the comments are
not deleted.

This really changes my difficult task to no problem at all.

THANKS AGAIN Mike,

Best regards,

Zorrozac