How to Copy Data from Protected Sheets in Excel?

The Excel sheets where we can put some restrictions on the sheet are known as "protected sheets." In Excel, you may want to copy protected data to another sheet or within the same sheet at times. If we try to copy the data directly, then Excel will not allow us to copy the data. But we can use the tricks given in this tutorial to copy the data from a protected sheet.

Read this tutorial to learn how we can copy data from a protected sheet in Excel. We can solve this task using these two methods. The first method is to use VBA, and the second is to use the name box.

Copy Data from a Protected Sheet Using Name Box

Here we will select the data using the address box, then copy the data, and finally paste the data. Let's go over a simple procedure for copying data from a protected sheet using the name box.

Step 1

Let us consider any protected sheet.

When we try to select the data in the protected area, an error will appear, as shown in the image below.

First, click on the name box, enter the range of data you want to copy, and click enter. Then use the command "CTRL + C" to copy the data, and in any other workbook, use the command "CTRL + V" to paste the data.

Name box > Range > Enter > CTRL + C > CTRL + V

Copy Data from Protected Sheet Using Vba

Here we will use the VBA application to complete our task. Let us look at a simple procedure for copying data from a protected sheet using the vba application .In this case, the whole sheet will be copied.

Step 1

Let us consider the same sheet that we used in the above example.

Then right-click on the sheet name and select View Code to open the VBA application. Then in the vba application, use the command "CTRL + G" to open the immediate and enter "Activesheet.cells.select" in the text box as shown in the below image, and click enter.

Right click > View code > CTRL + G > Activesheet.cells.select > Enter

Step 2

Then in Excel, use the command CTRL + C, and the whole worksheet will be copied.

Conclusion

In this tutorial, we used a simple example to demonstrate how we can copy data from a protected sheet in Excel.