Hi FSC,

I've tried this :
Sub diab()
Application.OnKey "^{v}", ""
Application.CommandBars.FindControl(ID:=22).Enable d = False
End Sub


Rgds,

Halim

FCS menuliskan:
How can I restrict the "Paste" functionality in Excel to prevent the user
from pasting cell formats when copying and pasting? (i.e. only allowing
pasting values and/or formulas)

I am using Excel 2003