Keyboard shortcut for paste unformatted in PowerPoint 2007

Is it possible to create a keyboard shortcut to paste unformatted text into PowerPoint 2007 using VBA or some other method?

Thanks for the help!
hsrstudAsked:
Who is Participating?
 
Chris BottomleyConnect With a Mentor Software Quality Lead EngineerCommented:
APologies my previous submission is reproduced here ... I meant to object

The author comment is wrong and represents an excel solution that to the best of my knowledge cannot be used in PPT.

As I commmented that a button for the purpose could be used, (via a macro) but that the useability improvements would be minimal I suggest that I answered the question reference a keyboard shortcut being impossible but introduced the idea of another way and that as such my answer was correct above and beyond.

Note if the use of a button had been requested I would have suggested something like the snippet below which uses the PPT interface and constants instead of excel.

Chris

Sub Macro1()
    ActiveWindow.Selection.TextRange.PasteSpecial ppPasteText
End Sub

Open in new window

0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
I don't think a shortcut key is possible though it may be possible to do it via a button As such though this wouldn't be much different to selecting on the edit menu.

Chris
0
 
hsrstudAuthor Commented:
For others that may be interested, this seems to work:

Option Explicit
Sub Paste_Unformatted_Text()
ActiveCell.Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
End Sub
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
Chris BottomleySoftware Quality Lead EngineerCommented:
The author comment is wrong and represents an excel solution that to the best of my knowledge cannot be used in PPT.

As I commmented that a button for the purpose could be used, (via a macro) but that the useability improvements would be minimal I suggest that I answered the question reference a keyboard shortcut being impossible but introduced the idea of another way and that as such my answer was correct above and beyond.

Note if the use of a button had been requested I would have suggested something like the snippet below which uses the PPT interface and constants instead of excel.

Chris
Sub Macro1()
    ActiveWindow.Selection.TextRange.PasteSpecial ppPasteText
End Sub

Open in new window

0
 
tajsimmonsConnect With a Mentor Commented:
I find the easiest option is to add a "paste special" button the Quick Access Toolbar.

If you choose "customize" , then on the "home" tab is a paste special button.

Cheers
TAJ Simmons
x MVP !
0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
Yah I assumed the request to bypass all inputs other than the specific paste unformatted which the pastespecial does not.

Adding a button to call the sub pastes unformatted with one press ... but it's not a keyboard shortcut of course.

Chris
0
 
GlennaShawConnect With a Mentor Commented:
0
 
hsrstudAuthor Commented:
Sorry, I got confused.  After I was unsuccessful trying to create a keyboard shortcut in PowerPoint to paste unformatted text, I moved on to Excel.  When I got it to work in Excel, I forgot this post was about PowerPoint and pasted code.  

It looks like GlennaShaw may have posted the solution, but I'm not willing to spend $30 for this feature, so I didn't try the recommended program. Seeing as there have been multiple approaches suggested, I'm going to split the reward.

Thank you for your help and I apologize for the confusion.
0
 
hsrstudAuthor Commented:
Here is another free solution that I found:

http://www.stevemiller.net/puretext/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.