For anyone interested, I figured out that protect and unprotect workexactly as stated in this email EXCEPT if the sheet is protected fromthe spreadsheet command bar before entering the vba module, theunprotect doesn't work.