How to copy a protected Excel sheet

To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets, you can protect the structure of your Excel workbook with a password. To copy a protected sheet means to create a duplicate of the protected sheet to paste it into some other sheet or location 

Our dataset below consists of a protected Excel sheet containing the data of a bank i.e., the name of the user and its corresponding account number, credit card number, and current account balance. Now we want to copy the data from this protected sheet and paste it into a new sheet. For this we have 2 methods, the first is by using the name box and the second is by using the Visual Basics application.

Method 1: Copy a specific range of data

Step 1 – Clear the Name Box

• Click on the Name box in the Taskbar 
• Remove the Cell name already written in it 

Step 2 – Type the Range of Cells

• After making the Name box clear, type the range of cells you want to copy 
• Here we have typed A1:B10, you may type any other range you want
• And press the Enter key

Step 3 – Press the CTRL+C keys

• After pressing the Enter key, press the CTRL+C keys to copy the selected range

Step 4 – Select the cell

• After copying the comment, click on the cell in the new sheet where you want to paste the copied comment

Step 5 – Press the CTRL+V keys

• After selecting the cell, press  the CTRL+V keys to get the required result

Method 2: Copy the complete sheet

Step 1- Press the ALT+F11 key

• In the Sheet you want to copy, press the ALT+F11 key and the Microsoft Visual Basic window will appear

Step 2 – Press the CTRL+G keys

• After the appearance of the Microsoft Visual Basic window, press the  CTRL+G keys to open the Immediate window 

Step 3 – Type the Code

• In the Immediate tab type the following code:
• Activesheet.Cells.Select
• After typing the code

Step 4 – Press the Enter key

• After typing the code, press the Ente key and the complete sheet will get selected

Step 5 – Press the CTRL+C keys

• After the sheet gets selected, press the CTRL+C keys to copy it

Step 6 – Select the cell

• After copying the comment, click on the cell in the new sheet where you want to paste the copied comment

Step 7 – Press the CTRL+V keys

• After selecting the cell, press  the CTRL+V keys to get the required result