PASTE SPECIAL VALUES.xlsm
Find the attached file for an example of forcefully paste special option