Buttons
Hi,
not sure if this is the correct forum, but here goes anyway: I have a Macro which works on a particular sheet. In that sheet I want to put a "button", so that when the user clicks on that button, the macro is invoked. How do I "draw" the button, and how do I assign the macro to it?? Many Thanks, Gary Thomson. |
Buttons
Gar
on forms toolbar there is "button" icon (light grey rectangle) which you can drag to required cell then right click mouse and assign macro to it Tin |
Buttons
Gary
You can also make a clickable button out of almost anything and assign a macro to it. Text box with text, Word Art object, drawing objects, an inserted graphic. Gord Dibben Excel MVP On Wed, 3 Mar 2004 03:41:05 -0800, "Tina" wrote: Gary on forms toolbar there is "button" icon (light grey rectangle) which you can drag to required cell then right click mouse and assign macro to it. Tina |
All times are GMT +1. The time now is 08:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com