Solved

Keyboard shortcut for paste unformatted in PowerPoint 2007

Posted on 2009-05-10
9
2,244 Views
Last Modified: 2012-06-27
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!
0
Comment
Question by:hsrstud
9 Comments
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 24352265
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
 

Author Comment

by:hsrstud
ID: 24361533
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
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 24371856
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
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 167 total points
ID: 24371861
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 9

Assisted Solution

by:tajsimmons
tajsimmons earned 166 total points
ID: 24373173
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
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 24374197
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
 
LVL 21

Assisted Solution

by:GlennaShaw
GlennaShaw earned 167 total points
ID: 24377289
0
 

Author Comment

by:hsrstud
ID: 24380583
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
 

Author Comment

by:hsrstud
ID: 24380684
Here is another free solution that I found:

http://www.stevemiller.net/puretext/
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Setting the Scene Animations in PowerPoint are a great tool to convey messages when used carefuly with the content of your slides. There are plenty of animation effects and options, including a Repeat feature for individual animation effects. …
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now