Question: how to copy an excel sheet that is protected?
Answer: Press Ctrl+Shift+F. On the Protection tab, uncheck the Locked box, and click OK. On the worksheet, select the cells you want to lock. Press Ctrl+Shift+F again. On the Protection tab, check the Locked box, and click OK. To protect the sheet, click Review > Protect Sheet.