Hi MD

Have you tried recording a Macro of your paste special routine?
Once you've done this you can attach the macro to a button on a toolba
or to an object on your spreadsheet such as a graphic or button.

Here is what you need.

Sub Paste_Text()
' Keyboard Shortcut: Ctrl+t
ActiveSheet.PasteSpecial Format:="Text", Link:=False
DisplayAsIcon:= _
False
End Sub

1) This code needs to live in a Module attached to your spreadsheet.
To see or add a VBA module select, Alt +f11. This brings up the Exce
VBA Project window.

2) Select your Personal.xls spreadsheet from the Left window and then
from the Insert menu, select  Module. This will save the macro to you
Personal worksheet and will be available whenever you open Excel.

3) Copy and paste the text above (from Sub to End Sub, inclusive) int
the Module.

4) Select the worksheet by selecting File... then
Close and Return to Excel.

You can access the Macro several ways. This first is use the shortcu
keys Crtl + t. This will call the Macro or you can use the keys Alt
F8 and select the macro to run (messy).

If you want to get fancy you can attach the Macro to a Toolbar.

Attaching the Macro to a Toolbar button
1) Right-click on the Toolbar and select Customize...
2) Select the middle Tab "Commands"
3) Scroll down the left window for Macros and select.
4) Click and drag and drop the smiley "Custom Button" up to th
Standard Toolbar.
5) Right click on the smiley button and select the last menu entr
Assign Macro...
A list of macros will appear including one named "Paste_Text"
6) Select that macro and click OK and Close the Customize dialog box.

Now your macro is available on your toolbar whenever you want. it

--
Message posted from http://www.ExcelForum.com

Other than the macro method, could you paste all data to NotePad first?

PaulyT: Thanks, the toolbar button works but the hotkey code does no
seem to work.

Dave: That would take longer than doing paste special.

I really wish there was just an option to not paste formatted text. Bu
I guess it doesn't exist

-
md103