Disable comments on mouse hover
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.
In the Excel>Preferences (called Excel>Options in some versions), General set Comments-None.
Disabling and Re-enabling COMMENT fields
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
This really changes my difficult task to no problem at all.
THANKS AGAIN Mike,