vba to make normal copy & paste work as copy paste special values

[Taskmaster013]

Hi,
I wonder if anyone can tell me how to do the following. I'm fairly sure it will be a vba that needs adding to my workbook.
I've built a workbook for other users but only want them to be able to copy, paste special values throughout the workbook. Can I either get the normal paste to act the same as copy paste special values or disable all other 'pastes' or make all of them act like copy paste special? It would be great if the users didn't know what was going on so when they copy & paste, they are actually paste specialling values by default,

thanks, Mike

 

[buxtongt]

Try:

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

Hope this helps.

 

[Taskmaster013]

Ok thankyou, I should have said, I'm fairly new to vba and not sure how I'd apply this to the full workbook,
Thanks in advance