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 |
Excel's draw tool to create a Macro Button
.... or from the forms toolbar, you can create a proper button to which you
can assign a macro, or from the control toolbox, you can also create a button which has the vb code directly linked to it... i think this might be what you mean instead of creating a shape? "JulieD" wrote in message ... 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 |
All times are GMT +1. The time now is 08:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com