Hi all,

I have a worksheet that I've created with very specific formatting. There are a few sections of cells within the spreadsheet that I have unlocked, that allow a user to change the values within them. The problem I am having is that I need to allow a user to copy values from another (any) spreadsheet and paste them into the unlocked cells in the formatted spreadsheet I have created, WITHOUT disturbing the formatting I have created (cell borders, colors, etc.).

I'd like to know if there was a way to have users who are pasting into these unlocked cells to ONLY allow values to be pasted... thus keeping my formatting intact.

Thanks for your help!