View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Preventing Info From Scrolling ... Possible ??

You're welcome, Mhz !

.. or making use of a Floating text Box.


I played with some past code by Orlando Magalhães Filho (below)
and it seems to do the above nicely (I just found the code <g)

Here's a sample file with the code implemented:
http://www.savefile.com/files/7433679
Floating Textbox Example.xls

Steps:
Draw a text box (default named:"Text Box 1") on the sheet first
Then install the code by right-clicking on sheet tab View code
then copy n paste Orlando's code into the code window
[ Adjust the x, y offsets to suit - I set these arbitrarily to 10]

'---
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
'by Orlando Magalhães Filho in .programming
x_offset = 10
y_offset = 10
ActiveSheet.Shapes("Text Box 1").Select
With Cells(ActiveWindow.Panes(1).ScrollRow, _
ActiveWindow.Panes(1).ScrollColumn)
xpos = .Left + x_offset
ypos = .Top + y_offset
End With
With Selection
.Left = xpos
.Top = ypos
End With
Target.Select
End Sub
'---

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mhz" wrote:
Thanks Max for the reply,
I wish they would work on expanding the Freeze Panes
or making use of a Floating text Box.
My Format is already spaced for Optimized Width and
It would be a bit more irritating to shift between windows,
But none the less your method appears to be the best at hand
... Thanks ..;)