View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BorisS BorisS is offline
external usenet poster
 
Posts: 191
Default code to unprotect sheet with password

I need to run a macro that first unprotects a password protected sheet, and
then reprotects it later, with a password. The user will not know the
password, and therefore the code needs to, itself, have it hardcoded in
there. I am not concerned about someone digging in the code and finding the
password, so assume that's not an issue.

Is this possible, and if so, what is the code?

Thanks.
--
Boris