Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
T-ReXTC
 
Posts: n/a
Default comments mouseover on frozen cells


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

  #2   Report Post  
Posted to microsoft.public.excel.misc
T-ReXTC
 
Posts: n/a
Default comments mouseover on frozen cells


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
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
Comments not anchored to cells Chris Excel Discussion (Misc queries) 3 February 5th 06 06:47 PM
make multiple cells in 1 worksheet equal multiple cells in another riley454 Excel Worksheet Functions 1 January 19th 06 03:00 PM
I want to show all comments on cells in one cell in the worksheet Claire Excel Worksheet Functions 1 June 17th 05 09:47 AM
comments in excel cells FDickens Excel Discussion (Misc queries) 1 March 18th 05 05:44 PM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM


All times are GMT +1. The time now is 09:52 PM.

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"