Excel 2003 Copy and Paste Issue (as simple as it sounds)

  • Thread starter Thread starter scottfeld
  • Start date Start date
S

scottfeld

As simple as it sounds, I am not able to copy and paste from one workbook to
another. I am able to copy sheets from one workbook and move to another, but
not a simple copy and paste function. This just started occurring 1 day ago.
I of course, closed everything down, and restarted the computer, but no
luck. Any helpful hints will be much appreciated.
 
Copy this snippet of code into a new workbook and see what you get for these
commands being enabled

Sub CopyPasteCommandBarCheck()
Dim myCommand As CommandBar

For Each myCommand In Application.CommandBars
If myCommand.Name = "Standard" Then
For i = 1 To myCommand.Controls.Count

If myCommand.Controls(i).Caption = "&Copy" Or _
myCommand.Controls(i).Caption = "&Paste" Then
MsgBox (myCommand.Controls(i).Caption & " Enabled:
" & myCommand.Controls(i).Enabled)
End If
Next i

End If
Next myCommand

End Sub

On my system, they are both enabled. I wonder if yours have been turned off
within some other code.
 
Where do I paste the snippet in Excel? I never had to do this before. Sorry
for the inexperience.
 
Close all workbooks and open a new one.
ALT F11
Insert Module
Paste into that module
Press F5.

I won't be available much longer, but will check back in a few hours.
 
Thank you. I was able to paste the code in. Two message boxes appeared when
I ran the code. "&Copy Enabled:True" and "&Paste Enabled:False". What do I
do to enable the paste function?
 
I'd try to replace

If myCommand.Controls(i).Caption = "&Copy" Or _
myCommand.Controls(i).Caption = "&Paste" Then
MsgBox (myCommand.Controls(i).Caption & " Enabled:
" & myCommand.Controls(i).Enabled)
End If

with

If (myCommand.Controls(i).Caption = "&Copy" Or _
myCommand.Controls(i).Caption = "&Paste") and _
not myCommand.Controls(i).Enabled Then
myCommand.Controls(i).Enabled = TRUE
End If

You must have some code somewhere in a workbook or add-in that turns this off.
 
It didn't work. I checked the code twice to make sure I had it in there
correctly too and I did. I'm not sure what to try now. Any other
suggestions?
 
Do a search for Reset Method in the VBE. You might be able to find something
there. I wish I could help you more.
 
Back
Top