PDA

View Full Version : how to force paste-special values in excel



CJ CHANDLER
08-30-2010, 10:53 AM
I am looking to write code in a spreadsheet (Excel 2007) that will force any pasting to be "paste-special values" while leaving the protected cells of my worsheet unlocked afetr pasting occurs. Any suggestions....I am a newbie to VB so be kind :)

CJ