MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy Cell Question

Posted by Dave Rube on June 22, 2001 12:05 PM

I have a worksheet which has many protected cells. My desire is for these to remain protected when other users utilize this worksheet. If I copy the tab to another worksheet in my existing workbook or to another workbook, the cell protection remains in place. However, if I simply select all cells and copy them to another worksheet, the protection is not existent in the new worksheet. Is there a way to insure that these attributes (cell protection) automatically go along with the new data, or better, is there a way to variably "turn off" copying with an attribute setting.

Posted by Kristen on July 01, 2001 9:18 PM

When you copy the sheet it brings the attributes of the sheet (ie protected) also. When copying cells you are probably bringing their 'protected' attribute across but as you aren't copying the sheet then there is no sheet protection on the new sheet. And locked cells aren't much use without cell sheet protection being on.