Keep text box visible
Excel doesn't have any event for scrolling.
But you could reposition the textbox after you've changed the selection.
If that's ok,
What's the name of the textbox?
Was it from the Drawing toolbar or from the Control Toolbox toolbar?
===
Someone did post an API/MSIE object (I think) that did do this, but it was too
complex for me.
Atishoo wrote:
Hi all
Am wanting to keep a text box visible while scrolling, I cant use freeze
panes as I need the whole page to scroll behind a position locked text box.
I am thinking can i create a formula to trigger when scrolling that will
dynamically recalculate the "top" property of the text box to hold it in
position??
--
Dave Peterson
|