Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cannot Move or Copy a worksheet
I am trying to copy a worksheet but it seems that that option (as well as all
but two options) are locked...I need to copy this worksheet only so I can email it without the recipient seeing the rest of them. Bryan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cannot Move or Copy a worksheet
A few possibilities:
..Workbook is protected (structure) ..You've already copied this sheet many times into the same workbook -- Excel seems to have a limit of about 30 copies, then won't do it any more due to its internal renaming convention (Sheet1 becomes Sheet11, then Sheet 111, then Sheet1111, etc, but only behind the scenes,) "Bern" wrote in message ... I am trying to copy a worksheet but it seems that that option (as well as all but two options) are locked...I need to copy this worksheet only so I can email it without the recipient seeing the rest of them. Bryan |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cannot Move or Copy a worksheet
Sounds like workbook protection is on. Remove and try again.
Regards Ken......................... "Bern" wrote in message ... I am trying to copy a worksheet but it seems that that option (as well as all but two options) are locked...I need to copy this worksheet only so I can email it without the recipient seeing the rest of them. Bryan |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cannot Move or Copy a worksheet
Is the workbook protected under ToolsProtection?
If so, unprotect it. You may need a password. Gord Dibben MS Excel MVP On Thu, 11 Sep 2008 11:40:00 -0700, Bern wrote: I am trying to copy a worksheet but it seems that that option (as well as all but two options) are locked...I need to copy this worksheet only so I can email it without the recipient seeing the rest of them. Bryan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can not copy or move some worksheet | Excel Worksheet Functions | |||
Move or Copy Worksheet | Excel Worksheet Functions | |||
Can't copy and move a worksheet | Excel Discussion (Misc queries) | |||
Move/Copy or Copy/Insert worksheet? | Excel Discussion (Misc queries) | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions |