worksheets("Sheet1").Unprotect Password:="ABCD"
' code
Worksheets("Sheet1").Protect Password:="ABCD"

--
Regards,
Tom Ogilvy

"neowok " wrote in message
...
hmmm what code would unprotect the sheet (including entering a
password)?

worksheet.unprotect(password) ?


---
Message posted from http://www.ExcelForum.com/