-
Disable comments on mouse hover
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
-
In the Excel>Preferences (called Excel>Options in some versions), General set Comments-None.
-
Disabling and Re-enabling COMMENT fields
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules