Cut, Copy, Paste, PasteSpecial grayed out.

[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.

[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?

--
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

[url="http://www.thecodecage.com"]Microsoft Office Help[/url]

[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" <Simon.Llo...@thecodecage.com> wrote in message
news:Simon.Llo...@thecodecage.com...

[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" <me@here> wrote in message
news:uU4P7k3d...@TK2MSFTNGP05.phx.gbl...

[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.

--

Dave Peterson

[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
"Dave Peterson" <pete...@verizonXSPAM.net> wrote in message
news:4B1D7499...@verizonXSPAM.net...

[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

--

Dave Peterson

[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

"Dave Peterson" <pete...@verizonXSPAM.net> wrote in message

news:4B1D7D2C...@verizonXSPAM.net...

[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).

--

Dave Peterson

[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

"Dave Peterson" <pete...@verizonXSPAM.net> wrote in message

news:4B1E6322...@verizonXSPAM.net...

[Dave Peterson]

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

--

Dave Peterson

[danlinett]

I created an account just to tell you that this worked for me. I had the same exact issue and it was plaguing me. I kept on thinking it had something to do with Macros. So thank you for this great post.

news.microsoft.com wrote:

Dave, this worked!
08-Dec-09

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

Previous Posts In This Thread:

On Monday, December 07, 2009 1:26 PM
news.microsoft.com wrote:

Cut, Copy, Paste, PasteSpecial grayed out.

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.

On Monday, December 07, 2009 1:46 PM
Simon Lloyd wrote:

Can you check to see if Ctrl+C and Ctrl+V work?
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 Wrote:

--
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

[url=&quot;http://www.thecodecage.com&quot;]Microsoft Office Help[/url]

On Monday, December 07, 2009 3:09 PM
news.microsoft.com wrote:

Simon,Ctrl+C and Ctrl+V work.

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

On Monday, December 07, 2009 3:48 PM
news.microsoft.com wrote:

Also I am able to "build" a custom toolbar with shortcuts that work.
Also I am able to "build" a custom toolbar with shortcuts that work. It is

just that they will not 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

On Monday, December 07, 2009 4:33 PM
Dave Peterson wrote:

I'd try this first.Rightclick on an empty spot on any of the toolbars.

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 have made to that toolbar, though.

"news.microsoft.com" wrote:

--

Dave Peterson

On Monday, December 07, 2009 5:01 PM
news.microsoft.com wrote:

Dave,BRILLIANT!!!That worked for the Main Menu Bar!

Dave,
BRILLIANT!!!
That worked for the Main Menu Bar!

The Shorcut (right click menu) still does not work and I do not see that on
the list.

Any idea how I can reset or repair that one?

Thanks,
Mike

On Monday, December 07, 2009 5:09 PM
Dave Peterson wrote:

Sorry, I did not notice the shortcut problem...
Sorry, I did not notice the shortcut problem...

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

If you are only concerned with the rightclick that shows up when you are in a
plain old cell in the worksheet when you are 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 Peterson

On Tuesday, December 08, 2009 8:53 AM
news.microsoft.com wrote:

Dave,Adding this command to the immediate window did not correct the

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

On Tuesday, December 08, 2009 9:30 AM
Dave Peterson wrote:

Try it again.
Try it again.

If it does not work, share what rightclick menu you are 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 are worried)

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

If you cannot 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 did not work, put your *.xlb file back (if you want).

"news.microsoft.com" wrote:

On Tuesday, December 08, 2009 10:51 AM
news.microsoft.com wrote:

Dave, this worked!

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

On Tuesday, December 08, 2009 11:40 AM
Dave Peterson wrote:

Glad it worked--but still curious why resetting the Cell popup did not."news.
Glad it worked--but still curious why resetting the Cell popup did not.

"news.microsoft.com" wrote:

Submitted via EggHeadCafe - Software Developer Portal of Choice
JavaScript - HighLight Keywords Like Google Does
http://www.eggheadcafe.com/tutorials/aspnet/e35a9390-476c-4651-abbe-330f8c511c5a/javascript--highlight-ke.aspx

[Dave Peterson]

Glad it worked for you.

--

Dave Peterson

[Bhameo]

How can I search a column for specific values and have all rows that contain
these values copied to another sheet?

[Mike H]

Hi,

Not too much infor but here's a macro that will do it. It looks in Column A.
Change the string to search for and the source and destination sheets to suit

Sub stance()
Dim MyRange As Range
Dim CopyRange As Range
Dim MyString As String
Dim SrcSht As String
Dim DestSht As String
Dim LastRow As Long
MyString = "XXX" ' change to suit must be in uppercase
SrcSht = "Sheet1" ' change to suit
DestSht = "Sheet2" ' change to suit
LastRow = Sheets(SrcSht).Cells(Cells.Rows.Count, "A").End(xlUp).Row
Set MyRange = Sheets(SrcSht).Range("A1:A" & LastRow)
For Each c In MyRange

If UCase(c.Value) = MyString Then
If CopyRange Is Nothing Then
Set CopyRange = c.EntireRow
Else
Set CopyRange = Union(CopyRange, c.EntireRow)
End If
End If
Next
If Not CopyRange Is Nothing Then
CopyRange.Copy Destination:=Sheets(DestSht).Range("A1")
End If
End Sub

Mike

[Gord Dibben]

Data>Filter>Autofilter.

F5>Special>Visible cells only.

Copy>paste to other sheet.

Gord Dibben MS Excel MVP

[hyn...@gmail.com]

The command worked for me. Thanks!

Dne pondělí 7. prosince 2009 23:09:48 UTC+1 Dave Peterson napsal(a):

[pronto...@hotmail.com]

SIMON LLOYD u area genius..thank you

it came back with the ctrl c and ctrl v
great!!!