LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 618
Default Excel's draw tool to create a Macro Button

Hi Paul

if you're meaning the shapes on the drawing toolbar then, click on the shape
you want, click on the worksheet where you want the button, then right mouse
click on the button and choose Assign Macro .. choose your macro and there
you have it (you can also right mouse click on the button and choose ADD
TEXT to put something on your button) - size / colour / shadow the button as
desired.

Cheers
JulieD


"Paul" wrote in message
...
How do I use Excel's draw tool to create a Macro Button?

Thx
Paul



 
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
Tool to automatically install a macro + button on 200+ instances ofexcel? [email protected] Excel Worksheet Functions 0 January 30th 09 11:49 PM
Draw border tool - Excel2007 Andi18 Excel Discussion (Misc queries) 0 September 5th 08 02:55 AM
Looking for a Macro or other tool to create a Workbook Content Sheet Victor[_2_] Excel Discussion (Misc queries) 1 February 7th 08 03:31 PM
Excel's camera tool Camera Shy Excel Discussion (Misc queries) 4 March 1st 07 02:03 AM
Draw tool bar RW Excel Discussion (Misc queries) 1 May 18th 05 08:30 PM


All times are GMT +1. The time now is 05:32 AM.

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

About Us

"It's about Microsoft Excel"