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,



  pj123 15:32 22 Nov 2003

That's a good question. I have the same type of thing on one of my excel progs, but I have given it a keyboard shortcut so wherever I am on the worksheet I just use "Ctrl + o" or whatever the shortcut is and it runs the macro. It would be interesting to know if the "button" could remain visible on the screen all the time.

I am sure that there are other ways but the way that I use is to use the Freeze panes facility for the window and place the button(s) in the top pane.


  VoG II 16:51 22 Nov 2003

I do the same as Whisperer.

The alternative is to create a floating toolbar (with only one button) that is created in an Auto_Open macro. You then need to be sure to remove it on exit in an Auto_Close macro.

  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

Motorola Moto G6 review: Hands-on

The best smart speaker: Apple HomePod vs Google Home vs Amazon Echo

Les meilleurs jeux gratuits pour Mac (2018)