Cut, Copy, Paste, PasteSpecial grayed out.

  • Thread starter news.microsoft.com
  • Start date
N

news.microsoft.com

Puzzling problem: In Excel both under "Edit" and in the shortcut menu "Cut",
"Copy", "Paste" and "PasteSpecial" are grayed out.

Just started today.Files are not protected.

These commands work fine in Word and Outlook. Have closed and re-opened
Excel. and Rebooted the computer to no avail.

Can someone help me?

Excel 2003,(Office 2003 Pro) Windows XP Pro SP3 Tablet Edition.
 
S

Simon Lloyd

Can you check to see if Ctrl+C and Ctrl+V work? if not it sounds as
though they may have been prevented via code.

You could check to see if the worksheet or workbook structure has been
protected, does this happen on a brand new instance of excel i.e Book1?

news.microsoft.com;579911 said:
Puzzling problem: In Excel both under "Edit" and in the shortcut menu
"Cut",
"Copy", "Paste" and "PasteSpecial" are grayed out.

Just started today.Files are not protected.

These commands work fine in Word and Outlook. Have closed and re-opened
Excel. and Rebooted the computer to no avail.

Can someone help me?

Excel 2003,(Office 2003 Pro) Windows XP Pro SP3 Tablet Edition.


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
 
N

news.microsoft.com

Simon,
Ctrl+C and Ctrl+V work.
Also theses items are grayed out in a new instance.ie Book1.
Thanks,
Mike

Simon Lloyd said:
Can you check to see if Ctrl+C and Ctrl+V work? if not it sounds as
though they may have been prevented via code.

You could check to see if the worksheet or workbook structure has been
protected, does this happen on a brand new instance of excel i.e Book1?

news.microsoft.com;579911 said:
Puzzling problem: In Excel both under "Edit" and in the shortcut menu
"Cut",
"Copy", "Paste" and "PasteSpecial" are grayed out.

Just started today.Files are not protected.

These commands work fine in Word and Outlook. Have closed and re-opened
Excel. and Rebooted the computer to no avail.

Can someone help me?

Excel 2003,(Office 2003 Pro) Windows XP Pro SP3 Tablet Edition.


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread:
http://www.thecodecage.com/forumz/showthread.php?t=160357

Microsoft Office Help
 
N

news.microsoft.com

Also I am able to "build" a custom toolbar with shortcuts that work. It is
just that they won't work from the shortcut and main menubars.

There are no protections set.
Annoying.

Have never heard of this one before.
If anyone has a solution, I'd be grateful.
Thanks,
Mike
news.microsoft.com said:
Simon,
Ctrl+C and Ctrl+V work.
Also theses items are grayed out in a new instance.ie Book1.
Thanks,
Mike

Simon Lloyd said:
Can you check to see if Ctrl+C and Ctrl+V work? if not it sounds as
though they may have been prevented via code.

You could check to see if the worksheet or workbook structure has been
protected, does this happen on a brand new instance of excel i.e Book1?

news.microsoft.com;579911 said:
Puzzling problem: In Excel both under "Edit" and in the shortcut menu
"Cut",
"Copy", "Paste" and "PasteSpecial" are grayed out.

Just started today.Files are not protected.

These commands work fine in Word and Outlook. Have closed and re-opened
Excel. and Rebooted the computer to no avail.

Can someone help me?

Excel 2003,(Office 2003 Pro) Windows XP Pro SP3 Tablet Edition.


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread:
http://www.thecodecage.com/forumz/showthread.php?t=160357

Microsoft Office Help
 
D

Dave Peterson

I'd try this first.

Rightclick on an empty spot on any of the toolbars.
Choose Customize (at the bottom)
Toolbars tab
Select worksheet menu bar
and click reset

And see if that helps.

You will lose any customizations you've made to that toolbar, though.
 
N

news.microsoft.com

Dave,
BRILLIANT!!!
That worked for the Main Menu Bar!
The Shorcut (right click menu) still does not work and I don't see that on
the list.

Any idea how I can reset or repair that one?

Thanks,
Mike
 
D

Dave Peterson

Sorry, I didn't notice the shortcut problem...

There are a bunch of rightclick areas that you could mean (or do you mean them
all???????)

If you're only concerned with the rightclick that shows up when you're in a
plain old cell in the worksheet when you're in Normal view:

Go into the VBE (alt-f11 is a quick way)
hit ctrl-g (to see the immediate window)
application.commandbars("Cell").reset
 
N

news.microsoft.com

Dave,
Adding this command to the immediate window did not correct the shortcut
menu. Items are still grayed out.
Any other ideas?
Thanks,
Mike
 
D

Dave Peterson

Try it again.

If it doesn't work, share what rightclick menu you're trying to reset.

===
You can reset all the toolbars if you want.

(Saved from a previous post)

The first thing I would do is reset my toolbar by deleting the associated
toolbar file (*.xlb).

Close excel
use windows search to look for *.xlb
and delete all that you find (or move them to a safe location if you're worried)

And remember to look through hidden folders, too. People can have trouble
finding them.

If you can't find your files using windows start button|Search, then you could
use an old DOS command to search and delete/move them

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir *.xlb /s

The /s says to search subfolders, too.

Make a note of the locations of the found files.

And delete/move them.

Then reopen excel and do some minor modifications. Then close and reopen excel
to see if it worked.

If it worked, make your real changes.

If it didn't work, put your *.xlb file back (if you want).

news.microsoft.com said:
Dave,
Adding this command to the immediate window did not correct the shortcut
menu. Items are still grayed out.
Any other ideas?
Thanks,
Mike
 
N

news.microsoft.com

Dave, this worked!
Deleting the .xlb file and having Excel replace it reset my right-click
shortcut menu.
Thanks for all your help!
Mike
 
D

Dave Peterson

Glad it worked--but still curious why resetting the Cell popup didn't.

news.microsoft.com said:
Dave, this worked!
Deleting the .xlb file and having Excel replace it reset my right-click
shortcut menu.
Thanks for all your help!
Mike
 

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

Top