P Pa Maher Apr 8, 2008 #1 Is there a way to turn off protection without the password? Or to create a copy that is not password protected?
Is there a way to turn off protection without the password? Or to create a copy that is not password protected?
G Gord Dibben Apr 8, 2008 #2 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
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