at the start of the sub enter

ActiveSheet.Unprotect password:="whatever"


at the end enter

ActiveSheet.protect password:="whatever"


--
irishboyx
------------------------------------------------------------------------
irishboyx's Profile: http://www.excelforum.com/member.php...o&userid=32498
View this thread: http://www.excelforum.com/showthread...hreadid=523162