Allow user to only paste values, not formats

[HRIS]

I have a workbook that is protected. In the workbook there are some cells that are not locked in which the user will want to paste data from another sheet. I am trying to figure out a way to force the paste to be values only, so the formatting on the sheet is not messed up. Is this possible?

Any ideas are appreciated!!!

 

[HRIS]

I read a recent post that sounded similar to what I am wanting (http://www.mrexcel.com/forum/showthread.php?t=578240&highlight=force+values+paste) but couldn't get the hidden format to work - so not sure if I am understanding it correctly...

 

[HRIS]

In case it is helpful to anyone else - I found another solution (in the below thread) which I tried and it worked out wonderfully for my workbook.
http://www.mrexcel.com/forum/showthread.php?p=2868609#post2868609