Re: "Paste-Special" Automation/Command Keys
- From: Steve Rindsberg <abuse@xxxxxxxxxxxxx>
- Date: Mon, 27 Aug 2007 11:10:59 EDT
Looks like a good solution but note that Alex mentioned *all* Office 2007 apps.
PowerPoint doesn't allow you to assign shortcut keys to macros, unfortunately.
Alex, if PPT becomes an issue, have a look at Chirag Dalal's Shortcut Manager
at http://officeone.mvps.org/
I don't know whether it works with Office 2007 but if so, it might solve the
problem for you.
In article <7J81J#F6HHA.4100@xxxxxxxxxxxxxxxxxxxxxx>, Jialiang Ge [MSFT] wrote:
Hello Alex,
From your post, my understanding on this issue is: you want to set shortcut
keys for the 'Paste Special' settings. If I'm off base, please feel free to
let me know.
I think we can do it by setting shortcut keys to macros that do the 'Paste
Special'.
Step 1: In the 'Developer' Ribbon of Microsoft Office, choose 'Record
Macro'. Name the macro and press OK.
Step 2: Record the macro: do your 'Paste Special' operations based on the
actual needs. For instance, you click the Paste->Paste Special Ribbon in
Home menu, and choose 'Unformatted Unicode Text'. Office will record all
your behaviors into VBA codes. Finally, click 'Stop Recording' and you will
find the macro's VBA in Microsoft Visual Basic Editor (Alt+F11). For
instance, for 'Unformatted Unicode Text', you will see VBA code:
Selection.PasteSpecial Link:=False, DataType:=20, Placement:=wdInLine,
DisplayAsIcon:=False
You can also refer to the page
http://msdn2.microsoft.com/de-de/library/microsoft.office.interop.word.selec
tion.pasteandformat(VS.80).aspx and
http://msdn2.microsoft.com/de-de/library/microsoft.office.interop.word.wdrec
overytype(VS.80).aspx to learn how to write Select. PasteSpecial without
the macro recorder.
Note: If you only do *ONE* PasteSpecial operation, such as 'Unformatted
Unicode Text', when you record the macro, it is possible that the macro
recorder regards it as your default operation and generates:
Selection.PasteAndFormat (wdPasteDefault). On such cases, you need to
modify the VBA according to the above two MSDN articles.
Step 3: Assign a shortcut key to the macro: Open the 'Word Option' window
by clicking 'Word Options' in Office 2007 menu. Switch to the Customize tab
and click the button Keyboard shortcuts Customize. In the Categories list
of the 'Customize Keyboard' dialog, choose 'Macros', then the macro
recorded in step2 will be listed. Set a shortcut key for the macro and
click 'Close'. The following URL links to a detailed description of how to
assign shortcut keys to macros in Office 2003.
http://wordprocessing.about.com/od/workingwithmacro1/l/blmacrokey.htm
Please let me know if you have any other concerns, or need anything else.
Sincerely,
Jialiang Ge (jialge@xxxxxxxxxxxxxxxxxxxx, remove 'online.')
Microsoft Online Community Support
==================================================
For MSDN subscribers whose posts are left unanswered, please check this
document: http://blogs.msdn.com/msdnts/pages/postingAlias.aspx
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications. If you are using Outlook Express/Windows Mail, please make sure
you clear the check box "Tools/Options/Read: Get 300 headers at a time" to
see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
.
- References:
- RE: "Paste-Special" Automation/Command Keys
- From: Jialiang Ge [MSFT]
- RE: "Paste-Special" Automation/Command Keys
- Prev by Date: Re: Powerpoint graphics filters
- Next by Date: Re: how to check if ppt file is valid ???
- Previous by thread: RE: "Paste-Special" Automation/Command Keys
- Next by thread: RE: "Paste-Special" Automation/Command Keys
- Index(es):
Relevant Pages
|
