View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
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