Thread: how do i copy protected spreadsheet in a macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote