Also to add to my latest post #6, is there a way to set a password when protecting and prevent from the end-user seeing the password. IE. I click the file and say protect sheet and use a password. Then I start adding rows and since in the macro, the logic is to unlock and lock the sheet, after the first attempt to unlock (and entering the password to unlock) and then lock I lose the password feature. If there is a way to address this and the solution is to hard code the password in the Macro logic, is there a way to prevent the end user from going to the developer tab > macro or view code to see the password?

Thanks
Antexity