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 2003

Gemma has attended:
Word Intermediate course
Excel Advanced course

Macros

when would we use them

RE: macros

Hi Gemma,

Thank you for your question.

If you had to import the same data from another file once a month, you could record a macro and then attach the macro to a button on your toolbar.

Then once a month, when it is time to import the data, just click on the button.

I hope this answers your question.

Regards

Simon

Wed 14 Oct 2009: Automatically marked as resolved.


 

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips


Server loaded in 0.09 secs.