ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Make CommandButton on Menu Bar (https://www.excelbanter.com/excel-programming/388791-make-commandbutton-menu-bar.html)

Minitman[_5_]

Make CommandButton on Menu Bar
 
Greetings,

I need to add three buttons to the top of my Excel window. I looked
at the Excel Help and could not find what I needed.

Anyone have any suggestions or ideas?

-Minitman

Jim Rech

Make CommandButton on Menu Bar
 
View, Toolbars, Customize. Then click the Coomands tab. You can drag any
Excel control to any Excel menu or toolbar. If you want the control to run
your macro rather than the built-in function, right click it (with the
Customize dialog still open) and pick Assign Macro.

--
Jim
"Minitman" wrote in message
...
Greetings,

I need to add three buttons to the top of my Excel window. I looked
at the Excel Help and could not find what I needed.

Anyone have any suggestions or ideas?

-Minitman




Minitman[_5_]

Make CommandButton on Menu Bar
 
Hey Jim,

Thanks for the reply.

I tried that.

I had that button on the menu bar in every application I opened, but
only on one machine.

I need this button to be on the menu bar for only one application,
wherever it is opened (private LAN).

Can this be done? If so, how?

Any help is greatly appreciated. TIA

-Minitman



On Fri, 4 May 2007 17:42:26 -0400, "Jim Rech"
wrote:

View, Toolbars, Customize. Then click the Coomands tab. You can drag any
Excel control to any Excel menu or toolbar. If you want the control to run
your macro rather than the built-in function, right click it (with the
Customize dialog still open) and pick Assign Macro.

--
Jim
"Minitman" wrote in message
.. .
Greetings,

I need to add three buttons to the top of my Excel window. I looked
at the Excel Help and could not find what I needed.

Anyone have any suggestions or ideas?

-Minitman





All times are GMT +1. The time now is 01:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com