Comments won't display on hover

Factotum

Board Regular
Joined
May 14, 2015
Messages
118
I've been searching too long on this with no luck. I've added some comments to cells in my spreadsheet using the following:

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?
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Works fine for me
How are you firing the code ?
Is the "Aging" named range more than one cell ?
 
Upvote 0
Wow, Friday must have been a rough day. As I tested it again this morning, it worked the first time. I stumbled on the fact that it was not working because my macro was still "running" as I was trying to debug it one line at a time. Apparently, comments will not be visible while debugging the macro. I would have thought that I had tested it enough times to have stumbled upon this. Sorry for the brain-dead question. Thanks, Michael, for taking the time to look at this for me. If nothing else, you gave me some new questions to ask and a new angle to look at things.
 
Upvote 0
We all have one of those days....(y)
 
Upvote 0

Forum statistics

Threads
1,215,518
Messages
6,125,293
Members
449,218
Latest member
Excel Master

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top