Unprotect worksheet from VBA question 1

[newboy18]

Please help, I have a sheet in a workbook that has password protected cells.
I want to change the contents of some these cells in VBA but I would need the routine to unprotect the sheet, update the cells and then re-protect the sheet with the same password.
Is this possible, if so how.

 

[Zathras]

See thread707-522755 for protecting with "UserInterfaceOnly"

 

[Simmy]

Sub Unprotector
Sheets("SheetName&quot.Unprotect("PasswordHere&quot
...
' Other lines of code here
...
Sheets("SheetName&quot.Protect("PasswordHere&quot
End Sub

Simmy

 

[venkman]

And if you for some reason need to break the password protection, there is an xla file that will do this for you:

http://www.straxx.com/excel/password.html

-Venkman

 

[newboy18]

Thanks guys, this works fine. VBA is like a mountain and I seem to have just climbed the first step - and that is after reading 2 books on the subject.