why will my copy and paste button not work

[Gerryites]

I seem to be unable to copy or paste anything. The icons on the tool bar are
shaded and unable to be used. Even if I right click the copy and paste
options are also shaded and will not work

 

[ryguy7272]

Maybe you can close Excel and reopen it, but that probably won't do anything.
This is more likely to help, but a little tricky to implement unless you
know VBA..do you know VBA?

Sub Enable()
Application.CommandBars.Item("Edit").Enabled = True
End Sub

Hit Alt+F11 and a window will open. Copy/paste the code into the window and
click the small green triangle at the top of the screen.


Hope that helps,
Ryan---

 

[Gord Dibben]

Is the worksheet protected?

Tools>Protection>Unprotect Sheet.


Gord Dibben MS Excel MVP