Question: how to copy from a protected excel sheet without password?
Answer: Step 1 Press ALT + F11 or click View Code on the Developers Tab.
Step 2 Double click on the worksheet that is password protected.
Step 3 Copy and paste the code below into the (Code) window. ... 
Step 4 Click on the Run Button or press F5.