Thanks Otto.......Unprotect and re-Protect

[CLR]

Thanks Otto...........

I wanted to know how to Unprotect and re-Protect a sheet in VBA and I looked
up this old response of yours and it does the trick just fine...........no
waiting............thanks for being there.......

Vaya con Dios,
Chuck, CABGx3



Unprotect the sheet before you start copying/pasting and protect it when
you're through. Use the following code. HTH Otto

Sheets("SheetName").Protect Password:="rob1"

Sheets("SheetName").Unprotect Password:="rob1"

 

[starwil]

u try to use programe for password recovery e.g.
Advanced office password recovery
or Advance VBA password recovery,
the former program is use to tickle office password include word & excel
while later is only unprotect VBA password, u can search in google.com and
find out these program with trial version (3 characters)

Regards,

William