Construction Estimating Software
Construction Accounting Software
Construction Software
Project Management SoftwareAccounting SoftwareBusiness Management SoftwareTime Tracking SoftwareConstruction Cost SoftwareConstruction ProgramsProject Estimating Software

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.