View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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