| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sheet and Workbook Protction
Is it possible to copy a sheet that is say a "template",
and is protected, to a new sheet, and have the protection "laws" apply to the new sheet? |
|
#2
|
|||
|
|||
|
Corey
Works for me in Excel97, 2002 and 2003 if the protected sheet is in a workbook that is not protected. Right-click on the sheet tab and "move or copy". Checkmark "create a copy" and in the "To Book" select which book and where in order and OK. Copied sheet in new book or same book is protected. Gord Dibben Excel MVP On Wed, 12 Jan 2005 09:40:40 -0800, "Corey Brock" wrote: Is it possible to copy a sheet that is say a "template", and is protected, to a new sheet, and have the protection "laws" apply to the new sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to use F9 to manually calculate in a single sheet or single workbook? | Excel Discussion (Misc queries) | |||
| Linking to an Entire Sheet | Links and Linking in Excel | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| format a 29 sheet workbook | Excel Discussion (Misc queries) | |||
Linear Mode
