macro

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macro

Macro

resolvedResolved · Low Priority · Version 2003

Karen has attended:
Excel Introduction course
Excel Intermediate course
Word Advanced course
Excel Advanced course

Macro

what is a macro

RE: macro

Hello Karen
Thank you for your question

When you have something you need to do over and over again you can write or record a macro to do it for you so you dont have to manually go through the steps each time. You can then attach the macro to a button in excel which can be clicked to perform the task or you could have it so that it automatically runs upon saving. You can use the macro recorder to build them which is best for beginners or directly write them in code if you are more advanced.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Tue 3 Mar 2009: Automatically marked as resolved.


 

Excel tip:

Using the Quick Access Toolbar in Excel2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Excel hints and tips


Server loaded in 0.09 secs.