View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Curt Curt is offline
external usenet poster
 
Posts: 469
Default 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