Is there a way to turn off protection without the password?
Or to create a copy that is not password protected?

Not without the password.

If the sheet protection was placed on with "allow users to select unlocked and
locked cells" you could copy the cells to a new worksheet.

Otherwise see John McGimpsey's site.

http://www.mcgimpsey.com/excel/removepwords.html


Gord Dibben MS Excel MVP

On Tue, 8 Apr 2008 10:55:02 -0700, Pa Maher
wrote:

Is there a way to turn off protection without the password?
Or to create a copy that is not password protected?