Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 683
Default Creating Buttons

I need to create a button to allow me to click on this button and run a
macro. I am almost positive I know how to assign the macro, I just can't
remember how to create the button in the first place. Can someone help?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Creating Buttons

ToolsCustomize Tools Tab and check the Forms box. Now, from that new
toolbar, click the button icon, and then draw it on the worksheet. It will
prompt for a macro to assign.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian" wrote in message
...
I need to create a button to allow me to click on this button and run a
macro. I am almost positive I know how to assign the macro, I just can't
remember how to create the button in the first place. Can someone help?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Creating Buttons

You can also assign the macro to any shape from the Drawing Toolbar.
(View...Toolbars...Drawing). Once you create the shape on your sheet,
you right click it to assign your macro.

OnceTall

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
Creating Custom Buttons bauman78 Excel Discussion (Misc queries) 3 August 26th 09 04:23 AM
creating buttons in worksheet Robert Excel Discussion (Misc queries) 1 December 19th 08 07:34 PM
Creating Macro Buttons and formatting Big H Excel Discussion (Misc queries) 0 November 1st 06 10:08 PM
creating buttons with a macro mike Excel Programming 3 January 26th 04 08:25 PM
Creating buttons using VBA CT[_2_] Excel Programming 7 September 10th 03 05:36 AM


All times are GMT +1. The time now is 02:55 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"