Excel Hints

Results 1 to 3 of 3

Thread: Disable comments on mouse hover

  1. #1

    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

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

  3. #3

    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
  •