Explain THIS ...

[Ray]

I'm hoping an MVP can help to explain this .... I originally posted
this question a couple of days ago:

**********
Excel won't allow me to copy a range from one sheet and paste on
another (within the same workbook)! I can copy the selected range,
but when I switch sheets, it's as if the CutCopyMode changes to False
or something.
**********

This same thing happens in most of my workbooks, but not all of
them .... I've investigated every setting I know of and they appear to
be set consistently among the workbooks.

This is getting REALLY annoying to deal with ....

ANYONE have ANY ideas?

TIA,
Ray

 

[Guest]

there may be some event macros.
try opening excel in Safe mode and see if the same thing happens.
If it doesn't, check for macros on on sheet modules, workbook modules or
otherwise.
there are a lot of the event macros for which this would be a by product.
Part of the reason I often will not use them.

 

[Guest]

I saw the other post and didn't really have anything to offer - still don't,
but...

Since you say "my workbooks" I'm kind of assuming they're ones you've
created yourself and don't have any code somewhere to inhibit cut'n'paste or
copy'n'paste.

The obvious culprits would be having either the individual sheets or the
workbook(s) protected from change - or both.

Some experimenting might help pinpoint the source of the problem.

#1 - can you copy from Excel into another application, such as a Word
document?
#2 - can you copy and paste within other applications such as Word or Notepad?

If you have pretty much lost copy and paste ability across the board (as
cannot do it in other applications either) then it points to a problem with
the clipboard itself and may require a repair installation of Windows to fix.

If this is strictly a problem within Excel then the quick fix attempt would
be to try a repair install of Office/Excel.

 

[Ray]

Thanks for the tips....

I'll check my Event code, as I know there are a couple of those --
what am I looking for? I thought that turning off things like this
(ie Application.CutCopyMode=False) were automatically 'reset' when the
Sub ended? It works that way for other settings right (ie
Application.DisplayAlerts).

JLatham -- I can actually copy/paste between workbooks, even if (in
one of them) I can't copy/paste WITHIN the workbook. It should be
noted that it's only SOME workbooks where I can't copy/paste within
the WB .... others are completely normal. I tend to think that it's
code related, although the offending WBs were working last week and
not much was done to them in the meantime. <shrug>

Thanks for the help though .... I'll keep searching!

 

[Guest]

Starting the offending workbook(s) with macros disabled should clearly
indicate if the macros were causing the problem

Vaya con Dios,
Chuck, CABGx3

 

[Ray]

Chuck .... tried that (macros disabled) and copy/paste worked again,
so it would seem that macros are the culprit. Turns out that there
are only a couple of Event macros -- a 'before_print', a
'before_save', and a 'worksheet_change' macro. None of these are
setting CutCopyMode to False ...

I'm stumped ....

 

[Don Guillett]

Try with ONLY that workbook opened.
Post your macros.

 

[Guest]

it doesnt have to formally set the CCM to false
and selection and action will do that in the background especially in the
worksheet_change macro

 

[Guest]

If you have not "saved", nor "printed" then those two macros would appear not
to be part of the problem. Pretty good chance that the "worksheet change"
macro is. Try just disabling that one macro alone, just to be sure.

I have found many times that I cannot directly "read" the code (especially
that contributed by much more accomplished programmers)....ie, it's not in
even slight english.........for that reason I lean toward more "readable"
code when I can, even tho it might not be as fast, it's at least editable in
the future (by me) when problems or changes occur. For the exceptions,
thorough documentation is a fair second place.

hth
Vaya con Dios,
Chuck, CABGx3

 

[Guest]

i had the same thing happen to me when i began using macros. my issue was
that i was using recorded code to switch workbooks and it defaults to
selecting a new cell on the workbook instead of activating it. after my
macro selected the data i wanted copied, it was changing the selection in
order to switch workbooks and therefore cutcopymode = false automatically. i
don't know if that's your issue but it could be so you might want to check
that. hope this helps get you closer to you solution.

-josh