Copy Worksheet of Locked Workbook
 

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?

--
Thanks! DSKR

Copy Worksheet of Locked Workbook
 

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?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Raisuli" wrote:

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?

--
Thanks! DSKR

Copy Worksheet of Locked Workbook
 

Did you try?.

The copied sheet will be an exact replica.


Gord Dibben MS Excel MVP


On Tue, 22 Sep 2009 12:40:01 -0700, Raisuli
wrote:

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?