Question: how to copy a protected excel sheet with password?
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.
Create a new sheet in the current workbook or in a different workbook (to create a new Excel file, simply press Ctrl + N).