I've been searching too long on this with no luck. I've added some comments to cells in my spreadsheet using the following:
None of the comments added in this method are visible when I hover with the mouse. When I add a comment manually, it shows up just fine.
When I run the following code in a separate module (after having run the code above), the comments are again visible on hover, but for some reason, this same code in the original module doesn't do any good:
I've already checked File-->Options-->Advanced-->Display and made sure that the box "Indicators only, and comments on hover" is selected.
Any other suggestions?
Code:
With Range("Aging")
.Value = "Aging"
.AddComment
.Comment.Text Text:="As of Report Date"
.Comment.Visible = False
End with
None of the comments added in this method are visible when I hover with the mouse. When I add a comment manually, it shows up just fine.
When I run the following code in a separate module (after having run the code above), the comments are again visible on hover, but for some reason, this same code in the original module doesn't do any good:
Code:
Range("Aging").Comment.Visible = False
I've already checked File-->Options-->Advanced-->Display and made sure that the box "Indicators only, and comments on hover" is selected.
Any other suggestions?