why will my copy and paste button not work

  • Thread starter Thread starter Gerryites
  • Start date Start date
G

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
 
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---
 
Is the worksheet protected?

Tools>Protection>Unprotect Sheet.


Gord Dibben MS Excel MVP
 
Back
Top