| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
| Copy worksheet from one workbook to a master workbook | Excel Worksheet Functions | |||
| How can user move in locked worksheet but not copy cell contents? | Excel Worksheet Functions | |||
| Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
Linear Mode
