Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comments not anchored to cells | Excel Discussion (Misc queries) | |||
make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
I want to show all comments on cells in one cell in the worksheet | Excel Worksheet Functions | |||
comments in excel cells | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |