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
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