Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print Frozen Panes? CyberSockeye Excel Discussion (Misc queries) 2 April 23rd 08 10:23 PM
Comments addede to cells above frozen panes are not entirely visib Hannes Hallik Excel Discussion (Misc queries) 1 November 29th 07 02:34 PM
frozen panes jmack Excel Discussion (Misc queries) 2 May 11th 07 09:00 AM
Comments Not displaying Correctly With Panes Frozen? Mattie Excel Discussion (Misc queries) 1 May 8th 07 05:31 PM
frozen panes question Gary Keramidas Excel Programming 4 October 19th 06 02:51 PM


All times are GMT +1. The time now is 10:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"