Problem with comments overlapping frozen panes

D

DeathSurfer

Duuuuudes:

I have the current problem. I am inserting comments programmatically to
cells in a given column. I am then using freeze panes on the column next to
the column with commented cells. The black line for the frozen panes is
cutting right through my comments when I mouse over them and if I have
scrolled the frozen panes to the left, the part of the comment that is
overlapping this frozen line is completely cut off. Is there any way to
alleviate this problem programmatically such as somehow hiding the freeze
panes line or moving the comments away from the line. I have tried the
following code but it doesn't seem to work:

Range(x).Comment.Shape.IncrementLeft 100

This I thought would have moved the comment over 100 pixels to the left but
actually doesn't move the comment anywhere. I know that if you manually move
a comment somewhere, once you mouse off of it, it returns to its original
location.

thanks,
DeathSurfer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top