Record a macro in PPT 2007

  • Thread starter Thread starter rhodesmk
  • Start date Start date
R

rhodesmk

I have Office 2007 Student/Home edition. I want to create a macro in Power
Point that will place the "degree" symbol after a number (small circle that
is placed immediately after a temperature).

I got it to work in Word just fine, but when I click "create" in PPT, I get
the Visual Basic program. I'm not a programmer by any stretch of the
imagination! I just want to insert this character without having to go
through a lot of clicks.

I know it's in the insert/character option as hex 00b0...just wanting to
save some keystrokes.

Thanks.
 
Why go to all that trouble just hold down the Alt key and press 0176 ° on
the numeric keypad.

--
Michael Koerner
MS MVP - PowerPoint


message I have Office 2007 Student/Home edition. I want to create a macro in Power
Point that will place the "degree" symbol after a number (small circle that
is placed immediately after a temperature).

I got it to work in Word just fine, but when I click "create" in PPT, I get
the Visual Basic program. I'm not a programmer by any stretch of the
imagination! I just want to insert this character without having to go
through a lot of clicks.

I know it's in the insert/character option as hex 00b0...just wanting to
save some keystrokes.

Thanks.
 
Sorry, my assumption was that your assumption would be I already tried that.
:-) Yes, I did try that, and it doesn't work in PPT 2007 for some reason.
Maybe because it's a laptop, and I'm using the numbers at the top of the
keyboard...maybe it'll work if I use the function key, too, but that's a lot
of kestrokes I can do away with if it's set up with a macro.

Thanks.
 
OK, let's assume that your assumption of his assumu... oh forget it. Let's
try this ...

Point a Macro Button to this code:

Sub Chillin(oSel As Selection)
If oSel.Type = ppSelectionText Then
oSel.TextRange.InsertAfter Chr$(186)
End If
End Sub

--
Bill Dilworth

vestprog2@ Please read the PowerPoint FAQ pages.
yahoo. They answer most of our questions.
com www.pptfaq.com
..
 
It does work in 2007. Looks like Bill Dilworth has come up with a solution
fort you.

--
Michael Koerner
MS MVP - PowerPoint


message Sorry, my assumption was that your assumption would be I already tried that.
:-) Yes, I did try that, and it doesn't work in PPT 2007 for some reason.
Maybe because it's a laptop, and I'm using the numbers at the top of the
keyboard...maybe it'll work if I use the function key, too, but that's a lot
of kestrokes I can do away with if it's set up with a macro.

Thanks.
 
OK, remember, I'm not a programmer, but I like to think I'm fairly
intelligent (ymmv).

I opended PPT, made sure macros are enabled (not recommended, but did it
anyway), clicked the Macro button, gave it the name "degree," clicked create,
highlighted everthing that was already in the box, pasted your code over it
all, told the program I wanted it in all open presentations, saved it, was
prompted to do a "save as" and made sure I selected the "macro enabled
template" option, saved it as degree.potm, closed everthing.

Re-opened PPT, went to "more commands," selected macros, wanted to add this
macro to the ribbon, but it's not there.

Went back to PPT, placed the cursor in a text box, clicked the macro button,
wanted to run the macro to create the degree symbol, but the macro isn't
there.

All this on my desktop, not the laptop. Running XP and Office 2007
Student/Home edition.

What did I miss?

Thanks for your help.
 
Back
Top