ComandButton Always on display

[MGumbrell]

I have a ComandButton1 at the top left hand side of my worksheet. When I scroll down the sheet the CommandButton1 dissapears (as expected). Is there a way to ancor it to a position so it remains visible when scrolling?

Thanks, Matt

 

[HaHoBe]

Hi, Matt,

ever thought about freezing panes? The hard way would be VBA but here I´d give the easy way a try... (tried it with Excel97 and it worked).

Ciao,
Holger

 

[MGumbrell]

Thanks Holger

That was embarrassingly simple.

Regards, Matt