Activate the protected sheet which you want to copy the data from, and then hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window, then press Ctrl + G Keys to open the Immediate window, and then copy the below script code into the Immediate window:Ģ. The following simple code can help you to copy data in active protected sheet, please do as this:ġ. This article, I will introduce some quick tricks for solving this task in Excel.Ĭopy data from protected sheet with VBA codeĬopy data from protected sheet with Name Box But the data in the protected sheet is not able to be selected and copied because of the user uncheck the Select locked cells and Select unlocked cells options when protecting the worksheet. Supposing, you receive an Excel file from another person which with worksheets are protected by the user, now, you want to copy and paste the raw data to another new workbook.
0 Comments
Leave a Reply. |