Thanks, Dave,

I can confirm it is NOT caused by workbook protection.

Every time, when I right click on worksheet name tab and select "Move or
Copy...", it is won't work if "Create a copy" was selected. Nothing will
happen. But with "Create a copy" unchecked, I can move the tab to everywhere,
both within workbook or other workbook.

I can actually insert a new worksheet and copy paste within the same
workbook to get the things done, but just do not know why worksheet copying
is not working.

thks


"Dave Peterson" wrote:

And you're sure that the workbook is not protected (not the worksheet)???

You may want to double check that.

If that's not the problem, maybe some more details of how it fails would prove
helpful.

Binyaaust wrote:

I got one workbook from overseas colleague and it NOT protected, no Macros in
it. But I cannot copy the worksheets either within it or to other workbooks.
I have tried Ctr+ mouse move, and right click--Move or copy.

have you anyone known what happened?

thks

--

Dave Peterson