View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Cut, Copy, Paste, PasteSpecial grayed out.

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

"news.microsoft.com" wrote:

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

"Dave Peterson" wrote in message
...
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" wrote:

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

"Dave Peterson" wrote in message
...
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

"news.microsoft.com" wrote:

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
"Dave Peterson" wrote in message
...
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.

"news.microsoft.com" wrote:

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.

--

Dave Peterson

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson