Move/Copy Worksheet -- does not work

G

Guest

When I right-click a tab in a worksheet and select to copy it into another
workbook. Nothing happens.

What could possibly cause Excel to fail to move/copy a worksheet?
 
G

Gord Dibben

Are you sure nothing happens?

Note the filename on the title bar.

Has it changed to the source workbook as it should?


Gord Dibben MS Excel MVP
 
G

Guest

Thanks for the feedback. I've checked the Protection status and it doesn't
seem to be protected... I've selected: Tools, Protection and Protect Sheet.
The "Protect worksheet and contents of locked cells" box is checked by
default though...

So, to make sure, I selected, copied and pasted all cells from this
worksheet into a new workbook and from there still cannot Move or Copy the
worksheet tab.

The filename on the title bar remains unchanged. However, the hourglass
pointer is shown for a half-second. Its almost as if Excel cannot complete
the Script or Process or whatever to move a worksheet.

I'm lost...
 
P

Pete_UK

Have you tried just dragging the sheet from its file window to another
file window (for move), or CTRL-drag for copy?

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel 2007 Move or Copy worksheet 2
How do i disable/enable "Worksheet Move or copy" option? 1
Worksheet does not copy 9
Excel Protection 2
Move or Copy Worksheet 6
Can not copy or move some worksheet 1

Top