 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007Copy-Paste
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? > Am using MS Office 2000 Premium, XP Service Pack 2 up-to-date. > [quoted text clipped - 5 lines] > TIA > MamaBee  SignatureDave Peterson 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 > Macros can kill the cut|copy mode. > [quoted text clipped - 9 lines] >>TIA >>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). > Hi Dave. > Only thing going is Conditional Formatting (5 conditions) to color [quoted text clipped - 17 lines] > >>TIA > >>MamaBee SignatureDave Peterson 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 > Close excel > Then open excel in safe mode [quoted text clipped - 41 lines] >>>>TIA >>>>MamaBee Possibly a sheet_activate event SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Am using MS Office 2000 Premium, XP Service Pack 2 up-to-date. > [quoted text clipped - 5 lines] > TIA > MamaBee
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.