advanced excel training - Assigning a macro to a button

The UK's most regular instructor-led training courses.
Training information: advanced excel training · Excel course · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Assigning a macro to a button

by - Duncan [guest] (2006 Nov 14 Tue, 09:08) Reply

We leant how to create macro toolbars on the course. How would I be able to embed a button on a worksheet and assign a macro to it, so that it can be sent to others?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 8 Tue	Bloomsbury	0	FULL
2003/XP	2008 Jul 8 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 Jul 9 Wed	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Tooting	0	FULL
2007	2008 Jul 16 Wed	Bloomsbury	7	book now	£202	£224
Full Schedule: See all 160 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Assigning a macro to a button

by - meenesh [guest] (2006 Nov 14 Tue, 09:15) Reply

Click on View- Toolbars and the Form toolbar. Form the Form toolbar you will see a Button icon ( 4th button alonf forms toolbar). Click on this and click where you want to put the command button. Once you have done this, the Macro window will open and you will be able to assign the macro to the button

· A Beginners Guide To Formulas In Excel
· Database Tips from an Excel Training Course
· How to Create Better Excel Spreadsheets: Part Four
· Tips to Facilitate Printing of Excel worksheets
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers