Question: how to copy a protected excel sheet to a new workbook?
Answer: 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.