microsoft excel courses in - macro imbedded button

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 courses in - Macro Imbedded Button

microsoft excel courses in - Macro Imbedded Button

resolvedResolved · Low Priority · Version Standard

Annabel has attended:
Excel Advanced course

Macro Imbedded Button

How do you create a button embedded in a worksheet to run a macro?

RE: Macro Imbedded Button

Hi Annabel,

Thanks for the question.

When you are on a spreadsheet make sure you have the forms toolbar on view. On that toolbar there is an option for button. If you click on that option and drag out a button it will automatically ask you which Macro you want to assign.

Hope that helps
Tracy


 

Excel tip:

Trace Dependents / Precedents without the blue arrows

Rather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula.

View all Excel hints and tips


Server loaded in 0.11 secs.