I have a protected worksheet with a range of unprotected cells to allow other users to enter data. Is there a way of ensuring that any data copied into these unprotected cells is copied as values only so that the formats I have set up don't get changed?
Bookmarks