Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make a commandbutton in Excel 'launch' a custom form? chorismos Excel Programming 2 October 12th 06 04:12 PM
how do i make a commandbutton run a macro?? Shax New Users to Excel 7 June 7th 06 05:16 PM
how to make a menu selection in the same cell? Eve Excel Discussion (Misc queries) 1 March 29th 06 08:29 PM
make a custom menu available to other users of Anthony Ponton Excel Programming 1 May 4th 05 06:34 PM
Using a macro to make selection in a drop down menu Ryan Graf Excel Programming 1 October 6th 03 07:35 PM


All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"