The MacNail construction accounting software worksheets
are shipped as protected documents. You will be unable to accidentally damage a protected document--the only
cells you can type into are ones that are OK to change.
As you get more experienced with MacNail and
Excel, you may want to remove document protection, temporarily or permanently.
NOTE-- In 2000, MacNail was replaced by
Goldenseal construction
accounting software. Goldenseal is an integrated program that
includes general accounting, job costing, payroll and
project billing, plus estimating and other features.
It automatically manages which accounting data can be
changed, and which is locked.
To remove document
protection:
1. Choose Unprotect Document from the OPTIONS menu.
2. If the OPTIONS menu shows Protect Document, the worksheet is already unprotected.
To restore document
protection.
1. Choose Protect Document from the OPTIONS menu.
2. When asked for a password, leave the box blank.
3. If the OPTIONS menu shows Unprotect Document, the worksheet is already protected.
Remove protection
if you want to:
1. Type into any 'locked' cells.
2. Change any formatting (column width, borders, alignment, style).
3. Use Fill Down, Fill Right, Copy and Paste, or Clear, or customize any formulas.
In a protected
worksheet:
1. You cannot accidentally damage anything.
2. The Enter key takes you to the next unprotected cell.
3. Unprotected cells will be underlined with a dotted line (if they have no bottom border).
In an
unprotected worksheet:
1. You can change anything. You can also cause damage to formulas or data structures, if you are
careless.
2. The Enter key enters whatever you have just typed, and keeps you in the same cell.
You must be
careful of the following actions in an unprotected MacNail worksheet.
1. Do not change any cell that includes a formula, unless you know exactly what it does. To see if
a cell has a formula--click in the cell, and check the formula bar (just below the menu bar) for anything that begins
with an = (equal sign).
2. Do not use Cut from the EDIT menu. Use Copy, Paste and then Clear instead.
3. Do not use Insert or Delete from the FORMULA menu. Use *Add rows, *Ledger Item or *Delete rows instead.
4. Do not use Delete, Set Database or Set Criteria from the DATA menu.
5. Do not use Sort from the DATA menu.
|
