how do i copy protected spreadsheet in a macro

[R Davis]

I need to copy and paste the values of a password protected worksheet via a
macro. The macro shuts down because of the protection. Is there a way
around this?

 

[Dave Peterson]

If you know the password, then include the code to unprotect the worksheet, do
the work and reprotect the worksheet.