Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2688
  • Last Modified:

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!
0
hsrstud
Asked:
hsrstud
3 Solutions
 
Chris BottomleyCommented:
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
 
Chris BottomleyCommented:
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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
Chris BottomleyCommented:
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
 
tajsimmonsCommented:
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 BottomleyCommented:
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
 
GlennaShawCommented:
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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now