Excel Macro button

  Simsy 15:10 22 Nov 2003
Locked

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,


Regards,

Simsy

  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,

Regards,

Simsy

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