Copy-Paste

  • Thread starter Thread starter MamaBee
  • Start date Start date
M

MamaBee

Am using MS Office 2000 Premium, XP Service Pack 2 up-to-date.

This problem occurs in one file only...... after copying a selection,
the paste/paste special function is unavailable on any other page of the
same workbook.

Can anyone tell what might be causing the problem in this file?
TIA
MamaBee
 
Macros can kill the cut|copy mode.

Do you have any automatic/event macros that fire when you change worksheets?
 
Hi Dave.
Only thing going is Conditional Formatting (5 conditions) to color
cell(s)based on text. I use CF in several files but it doesn't affect
the paste function in those.

Any other suggestion?
MamaBee
 
Close excel
Then open excel in safe mode
windows start button|Run
type this and hit enter:
excel /safe

Now file|Open yourworkbook.xls

And see if it works ok.

If it works ok, then I bet you have some event code that you didn't know you
had. You can look under the worksheet that you copied from. You can look under
the worksheet that you're going to paste to. You can look in the ThisWorkbook
module.

If you have no idea what this means, you can go back to the developer of the
workbook.

Or you can review the notes at Debra Dalgleish's site:
http://contextures.com/xlfaqMac.html#NoMacros

Debra's site is for another purpose, but it has some instructions with
pictures(!) that may help you get acclimated to the VBE (where macros live).
 
Thanks Dave. Your info led me in the right direction.
The problem is an add-in .... CFPlus.
When the sheet is de-activated (CF blocked, if you will), then the
copy/paste functions return.

I learned something new. Thanks.
MamaBee
 
Back
Top