Pasting values
Hi All
I am new to this forum, Just joined today.
My knowledge about excel and programming is at a very nascent
stage. Hopefully i would be develop that with help from
the contributors,forum members on this site.
My query : I Want a vba code where a user can only paste values
the values are copied from a different software where they will
do a ctrl + c on a number and then paste it in the cells.
for example there is a number 123456 they copy that paste it in c1
and the next number in c2 and so on.
*basically i want to restrict the user typing into these cells but only paste values. hence i think something needs to be done in VBA
Many thanx
Last edited by grkchakri; January 3rd, 2014 at 12:27 AM..
|