Copy Worksheet of Locked Workbook

[Raisuli]

Hi, I have a worksheet I want others to use but only be able to change a few
of the cells. I've locked all of the cells I don't want them to use and
protected the worksheet. However, I need the end users to be able to copy
the tab they've changed and save it as a secondary tab in the workbook. It
is possible to do this and keep the locked cells intact?

 

[Luke M]

As long as you only protect the sheet and not the workbook, users will be
able to copy the sheet. Note that the copied sheet will also be protected,
same as the original.

If the end user needs to be able to overwrite the previously protected
cells, they should insert a blank sheet, and then copy the cells from
protected sheet to the new sheet.

Does that answer your question?

 

[Gord Dibben]

Did you try?.

The copied sheet will be an exact replica.


Gord Dibben MS Excel MVP