Turn off Protection

numberpro

New Member
Joined
Dec 29, 2004
Messages
28
Hello,

Say that I have 5 protected worksheets. There are no passwords. It is a bit of a hassle to unprotect each. Is there a way to unprotect them as a group? something like control-click all and then select unprotect sheet?

Thanks.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,118,827
Messages
5,574,531
Members
412,601
Latest member
TheBeaniacExpress
Top