Excel Macro button

  Simsy 15:10 22 Nov 2003

Hi folks,
I have a simple sheet that has one simple macro.

I have the macro running from a command button. What I want to do is have the command button stay in the same place on the screen, so that if the sheet is scrolled, (which it will be, often and a significant amount), the button stays where it is so that it can be used.
Is this possible? If so how?

Alternatively, I could have it running via a button on a toolbar, but I only want this button/toolbar to be associated with this workbook. Is this possible? If so how?

Excel 2000 running on Win98se

Many thanks in anticipation,



  Simsy 19:37 22 Nov 2003

I hadn't thought putting it within the frozen pane section, even though there is one! I might do that a redesign the layout slightly.

I had breifly thought of the second option you suggest Vog, (A similar point made on MrExcel), but was hoping I'd missed something simpler. I may go down that route, just to prove I can!

Thanks for your interest folks,



This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Forza Horizon 4 review

Be Warned Mac users - Mojave Breaks Photoshop

iPhone tips & tricks

OnePlus 6T : date de sortie, prix et autres rumeurs