Unable To Move Or Copy Worksheet

[markkramer]

We have a workbook that does not allow us to use the Move or Copy command. When we right click on the worksheet and select Move or Copy, we are able to check the box to make a copy, but when we click OK nothing happens.

We have checked to make sure that the workbook and worksheet:
1. Are not protected
2. That there are no hidden worksheets
3. That there are not worksheets that exist with the same name
4. That not all the worksheets are selected

There are only two worksheets in this workbook.

Any ideas of why we are unable to make a copy of this worksheet within the same workbook or to another workbook?

 

[xenou]

You cannot delete worksheets in shared workbooks but that doesn't sound right here. There are ways to do this with macro code but I think you'd also know if there was code in the workbook. Otherwise, I'm stumped. I'd copy the worksheet to a new workbook (by copying the cells and pasting them on a new sheet) - then blast the existing workbook to blithereens.

AB

 

[markkramer]

Not sure what exactly went wrong but after we restarted the PC everything worked fine.

Thanks for all of your help!

M