how do i copy protected spreadsheet in a macro
 

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?

how do i copy protected spreadsheet in a macro
 

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



R Davis wrote:

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