After installing PowerPoint 2007 I noticed that the Macro Recorder tool was missing. Recently, while researching another annoyance of the PPT07 release I discovered that the Macro Recorder is still there, just hidden!
To start recording, just use the keyboard shotcuts: Alt+T -> M -> R
To stop recording: Do the same.
(Note: This shortcut is for an English version of Powerpoint 2007)
Tags: macro, office, powerpoint, ppt07, Tips, VBA
Hey clsc.net, Awesome! It works on my Power Point 2007. Just wondering why MS did not enable any toolbars, just like the previous versions. Thanks
dexter,
That question is one I’ve asked myself countless times the past few years. MS software is rightfully known to be able to make a grown man cry… In the case of PowerPoint 2007, believe it or not, they simply shipped a product that was not yet finished. That’s right. Of course it does work in most cases, but as soon as you start looking at automating it with VBA headaches are sure to arise. Lots of it isn’t even documented – for one thing, the extremely important slide property by the name of “Chart” is totally left out of the object model documentation (at least it was last time I looked, yesterday).
My guess is that somewhere along the line a decision was made that PowerPoint shouldn’t support VBA. And then later on they reversed that decision – a bit too close to the shipping date. And, as the shipping date came, the product just wasn’t finished yet. So, they shipped it anyway.
Yet another reason to avoid updating MS software to new versions for at least a year or two after launch, IMHO.
PowerPoint 2007 macro recording –
Yes, omitting the macro recorder was a major blow to me.
I have a system of generating powerpoint presentations from a list of images, movies, sounds, et al and a simple text description.
I used the recorder from Office 2000 to reverse engineer enough VB code to make all this work.
Those macros also work in PP 2007, but — there are still various mysteries, and each one takes much time and experimentation to decipher.
I use Perl scripts to open a PP session, load VBA macro text, then run it.
Also — can’t figure out which version I have — they left out the “Help – about” button.
Regarding ALT-T-M-R — yes, that opens a macro record box, and the thing generates a macro function — but there’s nothing in the function! So the recorder really is absent.
It worked! But I am not going to get to ecstatic as I’m sure there will be other problems.
Now I just have to clear out mountains of snow!
Thank you!
Marcus
awesome, thanks
The ATL T M R thing brings up the record macro dialogu. But nothing is recorded into the macro when you go to view macro to see the macro you just recorded.
I tried saving the file as a macro enabled powerpoint presentation at first.
I tried using ALT keys instead of the mouse in the hope that the keyboard would be recorded.
Is there anything else I should be doing?
It is amazing that there is no recorder.
I see almost no advantages to 2007 over 2000 but I was forced to pay for it as another generation of computers come out with it preloaded, and others start using pptx files. Microsoft appears to charge me for something that makes my life harder.
For some reason I am told that my comment seems “a bit spammy”.
I’m not sure why your comment gets a spam rating, it looks nice to me. However, software is not always logical
Unfortunately I have no idea why you can’t see the macro that you recorded. I cannot reproduce that problem, ie. I can see my own recorded macros.
I agree that Powerpoint 2007 has no advantages over the previous version. To me, it seems like a half-baked (unfinished) program.
>> Then you are either: not using PPT 2007, or you are a liar.
You can “turn on” macro recording, but only a sub is created, no real code is produced. MS even published a link.
@Leef_me, I believe you are incorrect. It does work as clsc.net reports. I’ve tested it on a few PC’s and have gotten it to work every time. It’s possible that what you are trying to record doesn’t record, as was the case in PowerPoint 2003 also. Try recording a macro where you change the orientation from landscape to portrait and when you press Alt+F11 to view the VB editor you’ll see the code.
Enjoy.
Timothy Takemoto you problem that you need to set security option.
see this web:
http://www.pptfaq.com/FAQ00033.htm
do that and it would work.
omar.rubio
In PPT 2007 ALT T M R does turn on/off the recorder, BUT only a (very) limited range of actions are recorded.
Here is what was recorded for me during a short session:
Sub Macro3()
ActiveWindow.Selection.Copy
ActiveWindow.Selection.Unselect
ActiveWindow.View.Paste
End Sub
However nothing regarding resizing or moving the copied image or adding a Text Box was recorded.
Similarily the Excel 2007 recorder does not record many actions dealing with charts that the Excel 2003 macro recorder captured.
Bottom Line: When I upgraded to Office 2007, I left the Office 2003 apps in place because of the superior macro recorder.
For Powerpoint 2007 Dutch version, use:
Alt-x, m, n – To start recording
Alt-x, m, o – To End recording
Good Evening,
I am trying to use this shortcut to for formatting a word within a text box and it is not recording anything?
Any advice, please?
Thank you.
I verified what Phil said. Very limited amount of actions can be recorded.
I wonder if it has to do with the change from menus to a ribbon.
I wish I had PPT 2003 back.