Cell Protection - How Do I Prevent Input

  • Thread starter Thread starter Craig Lescombe
  • Start date Start date
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
 
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top