Make default paste in Excel just text? 1

[RachelD]

Does anyone know a way to make the default paste in Excel 2000 be just plain text? Right now you have to go through the whole Paste Special, Text option.

Is there a registry hack or something?

TIA
Rachel

 

[ilses]

A registry change is not necessary.

You could change the Paste command itself with a macro, but I'd suggest you create a "mini" macro and assign that to a shortcut, e.g. Ctrl+Shift+P. Unless there is a good reaoson to do so, the less you change Excel's standard behaviour for simple functions, the better.

The macro needs one line only:

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

IS

 

[RachelD]

Do you know how to do this when the pasted data is coming in from another program (say Access). And by the way, I said Excel 2000 but it was Excel 97 and worked anyway.

 

[ilses]

Sorry , no I don't.

I've always happily copied and and pasted using Ctrl-C and Ctrl+V for single items such as a fax number from a database. For the rest, it's queries to retrieve data.

Maybe I don't understand your question correctly because of my lack of experience with Access.

IS

 

[RachelD]

We figured it out, just in case you were curious...

Sub pastetext()
'
' pastetext from keyboard Macro
'
' Keyboard Shortcut: Ctrl+q
'
ActiveSheet.PasteSpecial Format:="CSV", Link:=False, DisplayAsIcon:=False
End Sub