|Video Highlights – Excel 2010: Macros in Depth
(0:03) – Use the macro recorder to record your actions
The best way to get started creating a macro is by recording your actions. Even power macro users will use this as a fall back method for creating a macro.
Three ways to record a macro
- (1:11) Use the status bar button – In the lower left corner of your screen you’ll see the word Ready and to the right of it you might or might not be seeing a button. I’m not seeing a button here, so I’m going to right-click in that status bar. And you’ll notice a lot of selections here including one called Macro Recording. By checking this option, at the bottom of the screen we now have a button.
- (1:51) Use the view menu – Another way to start macro recording is to click the view tab in the Ribbon and the right-most button called macros. There’s a drop arrow there. Record Macro.
- (2:04) Add a developer tab to the Ribbon – A third way is adding a new tab in the Ribbon called Developer. We don’t really need to do that, but that’s another way.
(2:58) – Give your macro a good name
As you see more and more macros, many many times a good name helps define and describe what a macro does.
(6:24) – Warning – you cannot use Undo!
You cannot use the Undo feature to undo what you just did (i.e. with a recorded macro) and that makes us think about macros that might be deleting data… we want to stay away from those for a while.
(7:20) – Summary of video
We’ve just demonstrated the relatively easy process of recording a macro that’s going to be the dominant but certainly not the only method of creating macros.