Copy data from a protected excel sheet
Show
Read these next...
Hi Pavi , If you can use VBA , do the following : 1. Activate the copy-protected sheet. 2. In the VB editor , in the Immediate Window , enter the following statement : Activesheet.Cells.Select This will select all the cells on the sheet. 3. Open a blank workbook , or any other workbook where you wish to copy this sheet , and placing the
cursor in cell A1 , paste. Courtesy : http://www.excelforum.com/excel-general/385532-how-can-i-copy-a-protected-sheet-without-copying-the-protection.html Narayan
Hi Pavi , From within your worksheet , press ALT F11 ( the ALT key and the F11 key together ) ; this brings up the Visual Basic Editor ( VBE ). You should see the Immediate Window in the lower half of the screen ; in case you don't , press CTRL G to bring up the window. Narayan
Hello bobhc Excel ninja. I protected certain cells in the excel worksheet without editing (Using review> Protected sheet) but when I copy the worksheet, locked cells turn into unlocked cells and password is removed. 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. Can I do that Masters???
Atzmon 3,0411 gold badge15 silver badges22 bronze badges asked Sep 22, 2016 at 16:59
3 There is more than one way to copy.
answered Sep 22, 2016 at 18:14
1 Please try this, 1. Copy the cell locked/Protected sheet. 2. Paste on the next sheet or whatever the sheet you want. 3. Right-click the tab button. 4. And hit the "protect sheet" option. 5. Bingo! You will find the cells protected as same in the source sheet. Thank you, how to keep on the protection answered Jun 10, 2018 at 13:54
Can you copy data from a protected Excel sheet?Copy the protected sheet contents to another worksheet
Open the password-protected sheet. With the cursor positioned in cell A1, press Shift + Ctrl + End to select all used cells in the worksheet. Press Ctrl + C to copy the selected cells.
How can I copy data from a protected file?Permission Settings. Sign in to your computer using an account with administrator privileges.. Press "Windows-E" on the keyboard to launch File Explorer.. Navigate to the location of the write-protected file.. Right-click the file and select "Properties.". Select the "Security" tab, and then click the "Advanced" button.. Can protected sheets be copied?Protect a sheet or range. If you don't want people to change the content in a spreadsheet, you can protect it. This shouldn't be used as a security measure. People can print, copy, paste, and import and export copies of a protected spreadsheet.
How do I copy and paste protected cells in Excel?Copy data from protected sheet with Name Box. Input the cell range (D2:H13) into the Name Box directly, and press Enter key, see screenshot:. After pressing Enter key, nothing happens apparently. ... . Then press Ctrl + V to paste it to another worksheet where you want to copy the data.. |