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:
[Quoted Text] > "Curt" <Curt[ at ]discussions.microsoft.com> wrote in message
> news:68A190DF-56A2-41BD-A6A3-3B63F1DF5A6C[ at ]microsoft.com...
> > 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
>
>
>
>
|