Set paste option to always match destination format

[Ayush]

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.

[Eric B]

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.

[Glenny]

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.

[JonathanD]

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.

[Macarenas]

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.

[JustForFun]

Thanx man!!! it works ...

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.