PC Review


Reply
Thread Tools Rate Thread

comments mouseover on frozen cells

 
 
T-ReXTC
Guest
Posts: n/a
 
      9th Feb 2006

Hi all,

I have attached a comment to a frozen pane, and expecting it to do it's
mouse over popup below the "freeze-line", this is however not true, the
comment box is fixed to the original cells below the cell i created it
on, and therefore the comment disappear when scrolled down. Any way to
fix this or pop another floating textbox on mouseover?

T-Rex


--
T-ReXTC
------------------------------------------------------------------------
T-ReXTC's Profile: http://www.excelforum.com/member.php...o&userid=31352
View this thread: http://www.excelforum.com/showthread...hreadid=510483

 
Reply With Quote
 
 
 
 
T-ReXTC
Guest
Posts: n/a
 
      9th Feb 2006

got it working myself, code following for others
Label1 is the clickable area, and label 2 contains the info

Private Sub Label2_Click()
If (Label1.Visible = False Or Label1.Top + Label1.Height <
ActiveWindow.VisibleRange.Top) Then
With ActiveWindow.VisibleRange
Label1.Top = .Top + 5
Label1.Left = Label2.Left - 120
Label1.Visible = True
End With
Else: Label1.Visible = False
End If
End Sub


--
T-ReXTC
------------------------------------------------------------------------
T-ReXTC's Profile: http://www.excelforum.com/member.php...o&userid=31352
View this thread: http://www.excelforum.com/showthread...hreadid=510483

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comments addede to cells above frozen panes are not entirely visib Hannes Hallik Microsoft Excel Misc 1 29th Nov 2007 02:34 PM
Comments on frozen pain =?Utf-8?B?RmxpbnRz?= Microsoft Excel Misc 2 8th Aug 2006 04:41 PM
Comments frozen with shared Docs. =?Utf-8?B?Q2Fkd2Fu?= Microsoft Excel Discussion 6 21st Jul 2005 02:53 PM
Formulas in Comments or Mouseover? pikapika13 Microsoft Excel Misc 1 9th Nov 2004 11:12 PM
Mouseover comments like in Excel Tonya Marshall Microsoft Word New Users 2 28th Aug 2004 03:47 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:40 PM.