Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 20-03-2009
Member
 
Join Date: Dec 2008
Posts: 119
idea Set paste option to always match destination format

Hello Friends,

Whenever i try to paste anything in to a spreadsheet, it shows the paste option either on "Keep Source Formatting", or "Match Destination Formatting." Can any body tell me that how do i set pasting new data option automatically or try to keep it to always match destination format? Does any one have any idea that how can i do so? Any help on this would be appreciated.

Thanks a lot.
Reply With Quote
  #2  
Old 20-03-2009
Member
 
Join Date: Apr 2008
Posts: 4,641
Re: Set paste option to always match destination format

Do you have "preserve styles" turned on under Auto-Correct?

How can you stand that icon? First thing I do when they upgrade Word is turn all of those things off.
Reply With Quote
  #3  
Old 20-03-2009
Member
 
Join Date: May 2008
Posts: 4,565
Re: Set paste option to always match destination format

Put the following macro in normal.dot in order to intercept the
EditPaste command:

Sub EditPaste
On Error Resume Next
Selection.PasteSpecial Link:=False, DataType:=wdPasteText, _
Placement:= wdInLine, DisplayAsIcon:=False
End Sub

Hope so it may help you out.
Reply With Quote
  #4  
Old 20-03-2009
Member
 
Join Date: May 2008
Posts: 4,339
Re: Set paste option to always match destination format

If you find the Paste Options button distracting, or if you never use it, you may want to turn it off. Follow these steps.

1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.

2. Click Advanced at the left of the dialog box. (Click here to see a related figure.)

3. In the Cut, Copy, and Paste section, clear the Show Paste Options Buttons check box.

4. Click OK.
Reply With Quote
  #5  
Old 20-03-2009
Member
 
Join Date: May 2008
Posts: 4,829
Re: Set paste option to always match destination format

To make the macro universal, select OpenOffice.org at the upper-right (instead of the Writer option).

In the Keyboard tab, scroll down to the key(s) you want to use for your Paste Unformatted macro. Click once on the key sequence of your choosing.

At the bottom, under Functions, in the Category box scroll down to OpenOffice.org BASIC Macros. Double click it or single click the little plus sign. Next do the same for Standard below it. Single click on Module1. You should see your macro name appear to the right in the Function box. Single click it. Finally, at the upper-right again, click Modify.

Your macro is assigned to the key combination you chose. You can also add it to a menu by using the Menu tab instead of the Keyboard tab.
Reply With Quote
  #6  
Old 07-07-2009
Member
 
Join Date: Jul 2009
Posts: 1
Re: Set paste option to always match destination format

Thanx man!!! it works ...

Quote:
Originally Posted by Glenny View Post
Put the following macro in normal.dot in order to intercept the
EditPaste command:

Sub EditPaste
On Error Resume Next
Selection.PasteSpecial Link:=False, DataType:=wdPasteText, _
Placement:= wdInLine, DisplayAsIcon:=False
End Sub

Hope so it may help you out.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Set paste option to always match destination format"
Thread Thread Starter Forum Replies Last Post
copy/paste option is not working properly once clipboard becomes full in Microsoft Excel Raju Chacha MS Office Support 2 14-01-2012 03:29 PM
How to disable copy paste option in vista Gunter Windows Software 3 16-12-2011 02:02 PM
Match Destination Formatting as default in Excel 2007 NamJam Windows Software 7 29-11-2010 10:59 PM
Unable to use copy and paste option in Xp Anwar Operating Systems 6 14-03-2009 01:18 PM
Error - Driver components mis-match. Exit is the only option m3pilot Windows XP Support 2 31-10-2004 02:24 PM


All times are GMT +5.5. The time now is 05:27 AM.