 |
 | 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 / March 2008Copy Functionality Lost
Up until a day or two ago, I could select a cell to copy, paste it into another cell and the original copied cell would remain available to be copied again (it would be highlighted with the dotted border). Now, after one paste the copy cell reverts to normal, and I have to re-select it to copy into another location. I know I can use CTRL or SHIFT, but I find the retention of the copy ability useful. This is a networked office PC and imagine I might have to ask our IT Dept (as Administrator) to do something. Any ideas appreciated, thanks If you paste by pressing Enter you'll exit Copy mode. If you paste via Ctrl-v you should stay in Copy mode.  SignatureJim | Up until a day or two ago, I could select a cell to copy, paste it into | another cell and the original copied cell would remain available to be copied [quoted text clipped - 10 lines] | | Any ideas appreciated, thanks Hi Jim That doesn't work anymore either; no matter which way I copy - Keyboard, Mouse or Menu - I can only copy once. > If you paste by pressing Enter you'll exit Copy mode. If you paste via > Ctrl-v you should stay in Copy mode. [quoted text clipped - 15 lines] > | > | Any ideas appreciated, thanks I'd next guess that code is running when you paste. Right click the worksheet tab and pick View Code. If you see any code in the module that appears look for a sub named Worksheet_Change. This routine would run when you paste and it may be clearing the clipboard. It could be another sub though, e.g., Worksheet_SelectionChange. If you don't see anything then I don't know what's going on. SignatureJim | Hi Jim | [quoted text clipped - 20 lines] | > | | > | Any ideas appreciated, thanks Hi Jim Thanks for your help. I thought it was an Excel problem, but infact it is only the one workbook I am using at the moment. I will check for the codes you suggest. Regards > I'd next guess that code is running when you paste. Right click the > worksheet tab and pick View Code. If you see any code in the module that [quoted text clipped - 29 lines] > | > | > | > | Any ideas appreciated, thanks Jim I did find the Worksheet_Change and removed the routine. Everything is back to how I like it. Your help is really appreciated, especially as I was looking in completely the wrong direction! Regards > I'd next guess that code is running when you paste. Right click the > worksheet tab and pick View Code. If you see any code in the module that [quoted text clipped - 29 lines] > | > | > | > | Any ideas appreciated, thanks
|
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.