Automatically Paste Special Values in worksheet

[coreyjames]

I recently put together a template for some co workers. I want to be sure everything they paste into my template is pasted with special values. Is there a way to make it so anytime they ctrl+v or right click paste that it will always paste special values automatically. This would help speed up or process and work more efficiently. Thanks!!

 

[Smitty]

You could probably use a change event to convert whatever is entered into a value:

Private Sub Worksheet_Change(ByVal Target As Range)
    Target.Value = Target.Value
End Sub

Not that code is pretty broad based and won't exclude any ranges.

HTH,

 

[coreyjames]

Thank you. I was able to get this to work perfectly.