Cell Protection - How Do I Prevent Input

C

Craig Lescombe

Hello All - Thanks to all for previous help. New question - How
do I format specific cells that will prevent data from being
entered into these cells? These cells contain formulas
which calculate totals and subtotals, drawing their data
from other cells.

Thanks, Craig
 
F

Frank Kabel

Hi Craig
1. Select all cells for which you want to allow data entries
2. goto 'Format - Cells'. Choose the tab 'Protection' and uncheck the
protection for these cells
3. Protect your worksheet (goto 'Tools - Protection')

HTH
Frank
 
N

Norman Harker

Hi Craig!

If you use:

Tools > Protection > Protect Sheet

All cells in the sheet will be locked unless you have *previously*
used Format > Cells > Protection to remove the lock.

General process will be:

Decide which cells to allow access to
Select those cells
Format > Cells > Protection
Remove check from "Locked"
OK
Tools > Protection > Protect Sheet.

But note that Excel's internal protect of sheets and structure is
quite easily circumvented by free available code and workbooks. Only
regard it as a means of preventing accidental damage to formulas.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top