| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
cannot copy a worksheet within a workbook
I have been copying worksheets at the end of each month, but for some reason
I cannot copy the worksheets in the workbook. I have tried using the right click, the edit function, both are greyed out. Any suggestions? |
|
#2
|
|||
|
|||
|
Hi
check tools / protection / unprotect workbook a worksheet can not be copied if the workbook is protected. Regards JulieD "ROBERT P. SANDOZ" <ROBERT P. wrote in message ... I have been copying worksheets at the end of each month, but for some reason I cannot copy the worksheets in the workbook. I have tried using the right click, the edit function, both are greyed out. Any suggestions? |
|
#3
|
|||
|
|||
|
Is your workbook protected (toolsprotectionunprotect workbook)?
Regards, Peo Sjoblom "ROBERT P. SANDOZ" wrote: I have been copying worksheets at the end of each month, but for some reason I cannot copy the worksheets in the workbook. I have tried using the right click, the edit function, both are greyed out. Any suggestions? |
|
#4
|
|||
|
|||
|
What if the unprotect icon is grayed out from being used?
"JulieD" wrote: Hi check tools / protection / unprotect workbook a worksheet can not be copied if the workbook is protected. Regards JulieD "ROBERT P. SANDOZ" <ROBERT P. wrote in message ... I have been copying worksheets at the end of each month, but for some reason I cannot copy the worksheets in the workbook. I have tried using the right click, the edit function, both are greyed out. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| copy COLUMN from 1 worksheet to another (in a different workbook) | Excel Discussion (Misc queries) | |||
| Copying worksheet from workbook to another | Excel Worksheet Functions | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
| Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions | |||
Linear Mode
