Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel 2003 vba courses - Macros
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft excel 2003 vba courses - Macros
Resolved · Low Priority · Version Standard
Reply Fri 16 Nov 2007, 17:09Delegate Kate said...
Kate has attended:
Excel Advanced course
Macros
How do I create a macro button that sits in a cell on the spreadsheet and not in the toolbar?
For upcoming training course dates see: Pricing & availability
RE: Macros
Hi Kate, Thank you for your post, in answer to your question follow these steps:
Create your macro in the normal way, once the macro is created and named you can assign it to a button. To create the button open the Forms toolbar, View, Toolbars, Forms. On the Forms toolbar you will see the Command Button, click on the Button and draw a rectangle on the worksheet, immediatly you do so a dialog box will open asking for a macro to assign, click on the macro name of your choice. The macro is now assigned to the new button, with the button selected, (right click) you can change the default name to one of your choice, and format the text if you wish. Now by clicking on a target cell and then on the button the macro will run. I hope that is useful to you, regards Pete.
|