Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with comments overlapping frozen panes
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Frozen Panes? | Excel Discussion (Misc queries) | |||
Comments addede to cells above frozen panes are not entirely visib | Excel Discussion (Misc queries) | |||
frozen panes | Excel Discussion (Misc queries) | |||
Comments Not displaying Correctly With Panes Frozen? | Excel Discussion (Misc queries) | |||
frozen panes question | Excel Programming |