-
Similar Content
-
By zines
Hello,
I have asked this question at a couple of other places and nobody has been able to come up with a solution. Before asking this question I already believed there wasn’t a solution to this, but I will try it again to see if someone should happen to have a solution for this.
In Excel when you copy a cell the border starts moving/flashing. Only when that border is moving you are allowed to paste its contents into another cell. Once the border is no longer moving, you are also unable to paste its contents. The other option is to double click on the cell or go into the formula bar to manually copy the data, which then you can paste as much as you want, at least until something else is copied.
Here is my problem. I have VB script within the “Private Sub Worksheet_SelectionChange(ByVal Target As Range)” section of my worksheet. So every time another cell is selected this script is run. The script works perfectly and I do not need this changed. The spreadsheet first needs to be unlocked before the script can run, so I had to put this at the top of the script “ActiveSheet.Unprotect” and this at the bottom “ActiveSheet.Protect”. When I select a different cell and the code hits either the unprotect or the protect commands, then the copied cell border is no longer flashing, so I can’t paste.
Is there a script of some sort that I can use so it retains the copied data? The script should only run when a cell is copied. I also don’t want to use the SendKeys function because that typically causes more issues then what it solves. I have always been wondering where Excel stores its data for copied cells, since usually copied data is stored in the windows clipboard, or some other dumping ground since Windows 7 & 8 no longer use the clipboard for copping data. So I don’t understand why Excel doesn’t use the same method as everything else when a cell is copied.
Other information asked from the other sites:
What is the code that I am using: The code that I am using can be found at the below link. It is the one with the green checkmark as the answer, the one that I wrote. Although, for the most part it is irrelevant to this issue, other than knowing that when it hits the unprotect line, that is when it removes the flashing borders of the copied cell. For this script you see here, the unprotect wouldn’t be needed, but due to the fact that there is a lot of code in other locations of this spreadsheet I had to put the unprotect in there due to the spreadsheet being protected. If I didn’t unprotect it here, then the script would error out because it isn’t able to make changes.http://stackoverflow.com/questions/17005931/excel-2010-vb-script-highlight-row-issue
Clarification on how I am copying cells: Someone thought I had script to copy a cell from point A to point B. No, when I say copy I am just using the typical Ctrl + C on the keyboard. Due to the script activating as soon as another cell is selected, it prevents the copied cell from remaining active so I can never paste.
This isn’t too major of an issue since cells are very rarely copied in this spreadsheet, but just knowing the fact that it doesn’t work is driving me crazy, I like things to fully work the way they are supposed to. I would greatly appreciate it if someone knows of a solution to this.
Thanks,
Chris
-
By AitchB
I want to install a home based server to hold my backups. I have discounted using a paid service like Dropbox or several other similar cloud services, because they are too expensive (example: Dropbox = 1$/GB per year.) I currently have 2x2TB external HDDs that I alternate for my Mac using Time Machine and then I keep all my media files on another 2TB external HDD backup to the last 2TB external HDD. They are all kept in the same place next to the computer and I am aware that in case of a fire or a burglary they all might disappear, so every time the house is empty I hide some of the HDDs. Not an elegant solution.
There are 2 possibilities: First take the backup disks to another part of our (large) house where they will be hidden and no-where near the computer and then link them directly to the Mac. BUT HOW? long USB? Powerline RJ45? The HDDs of course do not have RJ45 sockets.
Secondly use a home server like a WD cloud server hidden away as above. These are called NAS servers. Which ones are good but not ridiculously expensive (up to say 300$) using some of those 2TB HDDs in it or connected by USB?
A completely off site server might be too slow. We live in the country and although the Internet connection is good I think it might be a problem.
I'd appreciate ideas and even a short discussion.
Henry
-
By Tony UT
I am looking to back up and possibly actively mirror a folder across multiple computers in a network. I have a test folder that will work for testing, but the files in this folder will be edited and saved on multiple computers in the same day a small garage fire in the spring destroy most everything that was active so in the network will have computers in the garage, shop, and house, along with a network drive in the house.
test files will be from the electric sheep program, and on 2 computers and a network drive another computer or network drive needs to be set up as a time machine backup in case a file gets accidentally deleted or saved wrongfully. "C:ProgramDataElectricSheepcontent" "\WDMYCLOUDSmartWareElectric Sheep" "\FRED-505ElectricSheepContent"
A 4th location can be kept for a time machine backup of which I also do not know how to do.
Windows 7/8 are my primary OS's
-
-
Who's Online 0 Members, 0 Anonymous, 21 Guests (See full list)
There are no registered users currently online
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.