excel

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Office general help » Excel

Excel

resolvedResolved · Low Priority · Version 2007

Julia has attended:
Upgrade to Office 2007 course

Excel

How do I record a new macro

RE: Excel

Hello Julia

Thank you for your question and welcome to the forum.

To record a macro in Excel 2007, you need to be able to see the Developer ribbon at the top of your screen.

If it isn't visible, then go to the Office button, select Excel options then go to Popular and tick Show the Developer tab in the ribbon'.

Then on the Developer ribbon, click the Record Macro button.

Give your macro a name (without any spaces in it) then click OK to start recording. When you have finished carrying out the steps that the macro should take, go to the Developer ribbon and click Stop Recording.

Kind regards
Amanda

Fri 11 Sep 2009: Automatically marked as resolved.


 

Microsoft Office tip:

Prevent macros from running when you start Applications

Macros are automated programs that can help you speed up your work. They can be embedded in caommands like AutoExec which will make them run as soon as an application like MS Word or MS Access are launched.
Sometimes it is useful to be able to switch off this function, and then can be done by the following method.
Hold down the SHIFT key when you click on the icon to start the program. This will suppress any automated macros.


View all Microsoft Office hints and tips


Server loaded in 0.06 secs.