Macro that retains password.

  • Thread starter Thread starter SpeeD72
  • Start date Start date
S

SpeeD72

Hi guys.

Im doing a macro that hides some rows and then protects a
sheet (sheet1). What i cant do is to retain the original
password protection for that sheet. I can´t make excell
ask me for a password either.

If this can´t be done, can i hide some rows and protect
them with a password so that nobady can unhide them??

Thanks a lot!!!
SpeeD
 
'hide your rows
activesheet.protect "Your password"
'to unprotect sheet
activesheet.unprotect "Your password"
 
Back
Top