microsoft excel training courses london - 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 training courses london - Macros

microsoft excel training courses london - Macros

resolvedResolved · Low Priority · Version Standard

Stephen has attended:
Excel Intermediate course

Macros

What is macros and how do you use them? What does enabling them mean and what does disabling them mean?

RE: Macros

If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task.

For example, if you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps.

Recording macros
When you record a macro, Excel stores information about each step you take as you perform a series of commands. You then run the macro to repeat, or "play back," the commands. If you make a mistake when you record the macro, corrections you make are also recorded. Visual Basic stores each macro in a new module attached to a workbook.

Making a macro easy to run
You can run a macro by choosing it from a list in the Macro dialog box. To make a macro run whenever you click a particular button or press a particular key combination, you can assign the macro to a toolbar button, a keyboard shortcut, or a graphic object on a worksheet.

Enabling or diabling a macro is a feature of medium level security settings of macros. You can set it to high , medium or low, depending on your preference.


 

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips


Server loaded in 0.07 secs.