Consulting

Results 1 to 3 of 3

Thread: Disable comments on mouse hover

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Jul 2008
    Posts
    2
    Location

    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
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,778
    In the Excel>Preferences (called Excel>Options in some versions), General set Comments-None.

  3. #3
    VBAX Newbie
    Joined
    Jul 2008
    Posts
    2
    Location

    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
  •