I have a macro that will copy one worksheet to a new one. My user wants
parts of the first worksheet protected (locked cells). When I try to run the
macro, it returns an error due to the protection. How do I write code to
unprotect the current worksheet so I can create a new one - and not have the
user enter the password??

Karen.....