how do i copy protected spreadsheet in a macro


R

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?
 
Ad

Advertisements

D

Dave Peterson

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

Top