| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying a worksheet witrh protected cells to a new worksheet
I have a worksheet that has certain cells in certain columns that are
protected so that formulas cannot be accidentally overwritten. However, when I go to paste that sheet into a new worksheet, it will not copy to the new worksheet. How can I make this work? -- John T. Sullivan |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying a worksheet witrh protected cells to a new worksheet
Unprotect the sheet, create the copy, protect original sheet.
Thats unless you are trying to copy someone elses hard work. "John" wrote in message ... I have a worksheet that has certain cells in certain columns that are protected so that formulas cannot be accidentally overwritten. However, when I go to paste that sheet into a new worksheet, it will not copy to the new worksheet. How can I make this work? -- John T. Sullivan |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying a worksheet witrh protected cells to a new worksheet
I meant to say that I wanted to make multiple copies of the original sheet
and have them automatically protected just as the original worksheet is...wanted to know if there is a way to do that. -- John T. Sullivan "Tiscali NewsGroup" wrote: Unprotect the sheet, create the copy, protect original sheet. Thats unless you are trying to copy someone elses hard work. "John" wrote in message ... I have a worksheet that has certain cells in certain columns that are protected so that formulas cannot be accidentally overwritten. However, when I go to paste that sheet into a new worksheet, it will not copy to the new worksheet. How can I make this work? -- John T. Sullivan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I use open/close Grouped cells in a Protected Worksheet? | Excel Discussion (Misc queries) | |||
| zero value when copying cells between worksheets | Excel Discussion (Misc queries) | |||
| Copying cells from 1 worksheet to another | New Users to Excel | |||
| copying cells to another worksheet | Excel Worksheet Functions | |||
| Unlocking Cells when a worksheet is protected... | Excel Discussion (Misc queries) | |||
Linear Mode
