microsoft excel 2003 vba courses - macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel 2003 vba courses - Macros

microsoft excel 2003 vba courses - Macros

resolvedResolved · Low Priority · Version Standard

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?

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.


Server loaded in 0.09 secs.