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 » Macros

Macros

resolvedResolved · Low Priority · Version 2007

Robert has attended:
Excel Advanced course

Macros

How do i attach a macro to a button?

RE: Macros

Hi Robert,

Thank you for your question.

If you go to the Developer tab and then choose the Insert option from the Controls group.

Add a grey button from the Form controls toolbox. When you have finished drawing your button a dialogue box will appear asking you which macro you want assigned to the button.

I hope this answers your question.

Regards

Simon

Mon 16 Nov 2009: Automatically marked as resolved.


 

Excel tip:

Create Charts with One keystroke

Create a graph with one click

1. Select your data.
2. Press F11.
3. You have a graph.

View all Excel hints and tips


Server loaded in 0.09 secs.