Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros
Resolved · Low Priority · Version 2007
Hello Dilly
Thank you for your question.
To create a macro in Excel 2007, you need to use the Developer tab.
If this is not visible in Excel, go to the Office Button, and select Excel Options. Then ensure 'Popular' is selected from the left hand side of the screen; and tick the box that says 'Show Developer tab on ribbon'; then click OK.
Once you can see the Developer ribbon, click the Record Macro button.
Give your macro a name (with no spaces), then click OK. You have now started the Macro recorder.
Go through the steps you would like the macro to peform for you, then go to Developer tab, and click Stop Recording when finished.
Kind regards
Amanda
|
|
Excel tip:Viewing Many WorksheetsIf there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds. |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.08 secs.
