Right Click Cut&Paste Not Working Anymore

[Danno]

Hi. I have Excel running on windows XP Pro and up until recently its been
working beautifully. But now for some reason when I want to copy a cell or
group of cells, when I select the cell by right clicking on it...there is no
option to cut OR copy. It was such a timesaver. Does anyone know how to
bring it back?

 

[Dave Peterson]

It sounds like something bad happened to the Cell toolbar.

You could try this to reset it.

Alt-F11 to get to the VBE
ctrl-G to see the immediate window
type this in and hit enter:
application.CommandBars("cell").Reset

close the VBE and back to excel to test.

 

[Danno]

Hi Dave! Thanks for responding. Ya, that's what's happened. The cell
toolbar (the window that opens when I right click on a cell) seems to be
damaged. I tried your suggestion, although I've never even seen Virtual
Basic before, and it has repaired the 'paste' function. But now that repair
you gave me is stuck on the clipboard and is the only thing I can paste. I
can paste it everywhere except on the walls of my house. And it's the only
thing I CAN paste.

I reinstalled MS Office yesterday thinking surely that would fix the
problem, but it didn't. I also did a 'dirty re-install of Win XP Pro'.
This is baffling because it is only in Excel and not Word. I'd sure like to
get this repaired because I use Excel a lot, and loss of this function is
not good.

Thanks again.

Dan

 

[Danno]

Hi again Dave. This problem seems to be a problem with the clipboard and
maybe not so much with the 'cell toolbar'. If I 'cut' or 'copy' something
onto the clipboard, once I've pasted it somewhere, it's still on the
clipboard. So the clipboard doesn't have room when I eventually try to cut
or copy something else. I think that's why the option to cut or copy
doesn't appear when I right click on a cell (because there is still
something on the clipboard that I had pasted somewhere. The clipboard tries
to hang on to an item I've put there, even though I've pasted it somewhere
else. Do you follow me?

Thanks again for your support.

Danno

 

[Dave Peterson]

Excel will remember what's in the clipboard until you copy something again.
(It's very useful sometimes.)

Did you try copying a different cell?

(actually you can clear the clipboard by copying something in excel (see the
marqee (or dancing ants)?), the hit the Escape key.)

The escape key won't clear the stuff you copied from a different application.
(well, it didn't for me in minor testing.)

 

[Danno]

Thanks for caring Dave! Yes, I've copied the 'pasted material' to several
different vacant cells. Then I go to another cell and right click on it,
with the intention to 'cut' it or 'copy' it, but those options are not
available. Just PASTE. It makes me so unhappy when that shit happens.

Danno

 

[Dave Peterson]

This may work.

Close excel
Use windows start button|find to search for *.xlb (where excel stores custom
toolbar info).

Rename it (them?) to *.xlbOLD.

Restart excel to see if you're ok.

If it does work ok, then dump those old files and recreate the customizations at
your leisure.

(did ctrl-C (copy) or ctrl-X (cut) work. Or even edit|copy or edit|Cut work?)

And one more if this didn't work. Does not available mean that it's not on the
popup menu or that it's greyed (disabled) on that popup?

Thanks for caring Dave! Yes, I've copied the 'pasted material' to several
different vacant cells. Then I go to another cell and right click on it,
with the intention to 'cut' it or 'copy' it, but those options are not
available. Just PASTE. It makes me so unhappy when that shit happens.

Danno

 

[Danno]

'Is not available' means that it wasn't on the menu at all. Not greyed
out...just not there at all. Instead... "Paste" was for some reason
dominant. Jesus, I could 'paste' what was on the clipboard all day long.

This may work.

Close excel
Use windows start button|find to search for *.xlb (where excel stores custom
toolbar info).

Rename it (them?) to *.xlbOLD.

Restart excel to see if you're ok.

If it does work ok, then dump those old files and recreate the customizations at
your leisure.

(did ctrl-C (copy) or ctrl-X (cut) work. Or even edit|copy or edit|Cut work?)

And one more if this didn't work. Does not available mean that it's not

Thanks for caring Dave! Yes, I've copied the 'pasted material' to several
different vacant cells. Then I go to another cell and right click on it,
with the intention to 'cut' it or 'copy' it, but those options are not
available. Just PASTE. It makes me so unhappy when that shit happens.

Danno

(see
the that
repair paste.
I the
only function
is recently
its copy a
cell know
how

[/QUOTE]

 

[Dave Peterson]

Did the rename stuff work?

'Is not available' means that it wasn't on the menu at all. Not greyed
out...just not there at all. Instead... "Paste" was for some reason
dominant. Jesus, I could 'paste' what was on the clipboard all day long.

 

[David McRitchie]

Hi Danno,
I usually use Ctrl+C and Ctrl+V to paste when that doesn't work
I next try the Edit menu. Next I think if you use notepad or editpad
as an intermediary you might be able to work with it.

I find that Search interferes either the START, Find in Win2000;
or the Ctrl+SHIFT+F in Outlook Express or both. Take them
down and start over. I find this especially annoying when trying to
paste from Message Source in Outlook Express that is within
an OE search. Was this the problem.

Another possibility is the Tools, Customize, Options tab,
make sure "Menus show recently used commands first" is unchecked.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Did the rename [toolbars .xlb] stuff work?

'Is not available' means that it wasn't on the menu at all. Not greyed
out...just not there at all. Instead... "Paste" was for some reason
dominant. Jesus, I could 'paste' what was on the clipboard all day long.