Recently I updated from 2004 to 2010 and have run into an issue with copying into a protected worksheet. There is a range that is a user input that must be copied in from another worksheet, but when the worksheet is protected the cells become locked as soon as copied.
Basically I would like the cells to remain the same in all aspects except the content. Is there anyway to copy and paste text only into the cells?
I would like to avoid the use of a macro if possible as well.
Basically I would like the cells to remain the same in all aspects except the content. Is there anyway to copy and paste text only into the cells?
I would like to avoid the use of a macro if possible as well.
