I want to copy the worksheet in the same workbook into different sheets as well as I want to keep the password without unlocking the cells editing even after copying the worksheet. The pasting as plain text option or Match Destination Formatting is probably the best route to take if you've already set up your spreadsheet and can't face having to set it up all over again by editing the Normal style. We would like for the file to open for the first person. The other sheet should have those same values at A20 X G39. If I open any spreadsheet on my computer, I can't copy and paste formulas, but do the exact same thing on the exact same spreadsheet on any other computer and it works no problem. You can open the clipboard and the paste will work, but there is no paste special option. This action will open the paste options where W means keep source column width, which should make the hidden columns hidden again.
Hope that's a good idea for you. Also with the script, almost all formatting is passed along with the biggest exception being conditional formatting. Please let me know whether it is doable. Thank to previous posts on that board tackling that issue, I was able to find how to proceed to reduce the file back to its normal size. To replicate a solved version of this problem create a new workbook, then: 1 On the Home Ribbon in the Styles section right click on the Normal box and click Modify. Thanks, Lynn Hello - I am using Excel 2007. It is not appropriate for people to use this forum to sell their services so you will probably not get any offers here.
The copied code now appears in the module window. Re-save the file in the xls format. For example, implement physical security, carefully screen and monitor people who have authorized access to your organization's data, and invest in user education so users understand what data should not be shared. Ctrl+X, Ctrl+V, Shift+Del, Shift+Insert that you don't want used. Each sheet's tab appears along the bottom of Excel. Being used by 110,000 elites and 300+ well-known companies. Select the range of cells that you want others to be able to edit.
I am trying this on his workstation and mine. What Operating system is the workstation hosting the share running? After pressing Enter key, nothing happens apparently. How do I find out what the current User's desktop folder path is each time the Marco is run by a different User? Any help would be greatly appreciated. The only thing you couldn't prevent in totality is taking pictures. Hi all, I've had a long search through your pages to see if this question has been answered before but having browsed through about 50 pages worth of threads I couldn't see anything, but if I am repeating prior information I do apologise. I have done this several times before.
It is the same Operating system and the same version of Excel. When I try to merge them, I get a warning that the selection contains multiple data values, and merging into one cell keeps the upper-left most data only. The formatting issue as least has a work-around where you can copy the correct formatting from another cell and paste it back in the messed up cell. It can be read, and copied but not manipulated in any way. I propose a different solution.
The subsequent columns describe the shape, color, and markings. . Today, when I go to open stuff. In the workbook you need to disable the cut, copy and paste functions, please press the Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window. It's at the top of the preview. So the concept of saving it as an image or pdf is not going to work for us.
Use ctrl c and ctrl v to copy and paste cells. I find it especially infuriating that this flaw has existed in Excel for decades and yet Microsoft's support website does not mention it at all. Any ideas how to fix this? Here is the solution for Excel 365. In my experience, that's very few people! If this doesn't work, your format protection feature doesn't work. To start viewing messages, select the forum that you want to visit from the selection below.
I wanted someone to be able to make selections within the document, but not be able to copy it and take it out of office. The only cell that text can be entered into now should be A1. How to copy data from protected sheet? They can copy and paste between worksheets. This will create a fresh sheet with no security attached to the document, even if read only is set. I don't want anybody else besides these two people to be able to even open the file, so I'm not talking about password protecting to prohibit editing a file.
If he decides to copy and paste data from another worksheet to mine then the cell formatting of the other worksheet is applied to my cells. I tried converting the table into text with manual line breaks and tab stops to divide columns and rows, but that didn't solve my problem. Ideally, the user can copy-paste-values from that locked cell an an unlocked cell. Find the little Excel workbook icon near the upper left corner of the window, just to the left of the File menu option. However, it contains hiddent rows and when I copy-paste it, the hidden rows are included. What are you supposed to do then? I have made an excel file where other people have to go in and update it. If not, you'll be prompted to enter a password into a pop-up window.