Automatic Cell Protection

Problem

they want to remove the automatic cell protection from worksheets used in MacNail construction management software

Diagnosis

A MacNail Manager protects their construction software files and they want it off.

Solution

For newer Excel versions:
1. Choose Name from the Insert menu, and choose Define from the submenu.
2. Fine always.protect in the list.
3. In the definition box it will say =TRUE. Change that to =FALSE.
4. Click OK.
5. Choose Save from the File menu to make the change permanent.

For older Excel versions:
1. Choose Define Name from the Formula menu.
2. Do steps 2 to 5 above.

Comments

Entered 6/24/03 by KCM. Updated 11/23/2010.