Copy Tab function not working
 

For some reason, the copy tab function is not working for me. I can move
Tabs, but when I highlight the tab(s) and select "copy", nothing happens.

Suggestions?

Thanks!

Copy Tab function not working
 

"Curt" wrote in message
...
For some reason, the copy tab function is not working for me. I can move
Tabs, but when I highlight the tab(s) and select "copy", nothing happens.

Suggestions?

If you've clicked on a worksheet's tab & selected "copy", then it should
have placed a copy of the currently selected cell or cells from that
worksheet into the clipboard, from which you can paste into another
worksheet (or elsewhere on that worksheet, or into another Windows
application). [You'll get an animated moving border around the cells that
have been copied, & you can clear that with the Escape key.] That's what
"copy" does, so I'm not quite sure what you mean by "nothing happens".

If you want to copy the whole worksheet, then the function you want is "Move
or Copy Sheet" (from the Edit menu, or by right-clicking the worksheet tab).

Did you try putting "copy tab" into Excel's help?
--
David Biddulph

Copy Tab function not working
 

David,

Sorry for the confusion....let me restate the question. I am attempting to
copy a worksheet (elsewhere in the current workbook or to another). I right
click on the tab name, select "move or copy" then click on the "create a
copy" box and select the destination. When I click "ok", the copy is not
created. If I do not select the "create a copy" box, then the tab is moved
to the destination properly. This is a function I have used countless times
in the past, so I am wondering if anyone has seen a glitch like this and if
so, do they have a solution (other than re-installing Excel).

Thanks for your response.
Curt

"David Biddulph" wrote:

"Curt" wrote in message
...
For some reason, the copy tab function is not working for me. I can move
Tabs, but when I highlight the tab(s) and select "copy", nothing happens.

Suggestions?

If you've clicked on a worksheet's tab & selected "copy", then it should
have placed a copy of the currently selected cell or cells from that
worksheet into the clipboard, from which you can paste into another
worksheet (or elsewhere on that worksheet, or into another Windows
application). [You'll get an animated moving border around the cells that
have been copied, & you can clear that with the Escape key.] That's what
"copy" does, so I'm not quite sure what you mean by "nothing happens".

If you want to copy the whole worksheet, then the function you want is "Move
or Copy Sheet" (from the Edit menu, or by right-clicking the worksheet tab).

Did you try putting "copy tab" into Excel's help?
--
David Biddulph

Copy Tab function not working
 

Nothing happens?

No error message?

If the workbook is shared you can move sheet tabs by dragging or right-click and
move, but cannot "create a copy".

You will get a message stating "you cannot do that on a shared workbook"


Gord Dibben MS Excel MVP

On Wed, 27 Sep 2006 08:33:01 -0700, Curt wrote:

For some reason, the copy tab function is not working for me. I can move
Tabs, but when I highlight the tab(s) and select "copy", nothing happens.

Suggestions?

Thanks!