Excel 2000 Scroll with button

[JamesNash]

Hi there Excel Guru,

I have created an excel worksheet with buttons and macro's attached to them.. how do I get the buttons to stay in view as I am scrolling down the page.... so in a way the button floats with the screen as you scroll down and doesn't disappear of the page...


Thanks in advance...

JN.

 

[xlbo]

Without some pretty hardcore coding, the only easy way is to use frozen panes and put the button within the frozen bit so that it doesn't actually move... Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[GlennUK]

Or you could put your buttons on a toolbar instead of embedding them in the worksheet.

Glenn.

 

[JamesNash]

Hey guys,

Thank you very much for taking the time to try and help with my query, but i am aware that i can use frozen pane and insert my buttons into the toolbar... this is not what i am really after,... thanks anyway...

cheers,

JM

 

[xlbo]

The problem is that there are soooo many ways of moving round a spreadsheet - it's an absolute nightmare to try and trap them all. I'm sure it's do-able but as I said in my 1st post - it'd require some pretty hardcore coding and even then, I'm sure it'd be easily breakable Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde