I would like for a command button to stay on sheet as I scroll, to allow the
option of clicking it wherever I 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

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

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

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