Only allow Paste Values

[RPhilbin83]

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!

[swoop99]

This has been discussed previously (see: http://www.excelforum.com/excel-gene...ata-entry.html)

The conclusion was that you may need to write a macro to run from the worksheet_change event to rewrite the correct formatting options you have set when a user makes a change.

[RPhilbin83]

Thank you for your response.

Is there any other way to detect when a user has pasted values into this spreadsheet? Or is this only done within the worksehet_change event?

[swoop99]

A quick google search is telling me this is fiddly. However, it may be possible to use the worksheet_change event to trigger the code and test the state of the cutcopymode flag to see if a user has used paste.

If you're going to go down this route.....good luck.....and I'd be very interested in seeing any solution you come up with.