Button to stay on screen as you scroll
 

I would like for a command button to stay on sheet as I scroll, to allow the
option of clicking it wherever I scroll

Button to stay on screen as you scroll
 

put the button in row 1

select row 3 and do Window=Freeze Panes

To undo the Frozen Pane, do Window = UnFreeze Pane

--
Regards,
Tom Ogilvy

"fred" wrote in message
...
I would like for a command button to stay on sheet as I scroll, to allow
the
option of clicking it wherever I scroll

Button to stay on screen as you scroll
 

Hi Tom,



select row 3 and do Window=Freeze Panes


btw: is there any possibility without freezing panes? I
thought about that too and also just made out the
freezing... but one should also can lock the button,
shouldn't?

Best

Markus

Button to stay on screen as you scroll
 

Is there no code like OnScroll or something that everytime you scroll you can
get the nwe coordinates of the page and feed these into the command buttons
positions??

Don't know if there is code for this, but it'd be worth investigating

"fred" wrote:

I would like for a command button to stay on sheet as I scroll, to allow the
option of clicking it wherever I scroll

Button to stay on screen as you scroll
 

I am not aware of any setting/property that would make it float.

If it is a button, I would use a floating commandbar, but that wasn't the
request.

--
Regards,
Tom Ogilvy

"Markus Scheible" wrote in message
...
Hi Tom,



select row 3 and do Window=Freeze Panes


btw: is there any possibility without freezing panes? I
thought about that too and also just made out the
freezing... but one should also can lock the button,
shouldn't?

Best

Markus