macros
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Macros

resolvedResolved · Low Priority · Version 2003

replyReply Wed 18 Feb 2009, 15:56Delegate Tina said...

Tina has attended:
Excel Intermediate course
Excel Advanced course

Macros

What are the steps to recording a marco?

For upcoming training course dates see: Pricing & availability

replyReply Thu 19 Feb 2009, 12:05Trainer Cress said...

RE: Macros

Hello Tina
Thank you for your question

Go to Tools, Macro, record new macro. Name the macro. Click OK. As soon as you click OK the macro is recording. Complete the action you want to record, for example clicking on a different tab of the workbook. When you are done then click the stop recording button which is the little blue square that appears. The macro has been recorded and can be assigned to a button etc.

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

Kind regards
Cress

Wed 25 Feb 2009: Automatically marked as resolved.

 

Please browse our web site to find out more about
excel+training+best and other Microsoft training courses.

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard