restricting user entering the value

  • Thread starter Thread starter mangesh
  • Start date Start date
M

mangesh

hi
i have spreadsheet and i want to allow the user to enter the values o
a particular column and restrict him to enter the values elsewere
 
Hi Mangesh!

By default all cells are locked when you impose worksheet protection.

First select the cells you will allow user access to
Format > Cells > Protection
Remove check from "Locked"
OK

Now use:

Tools > Protection > Protect Sheet
Give and confirm password [Optional]

I think it good practice to highlight the cells that the user has
access to with a different pattern. Best time to do that is when you
are removing the lock.

Be aware that worksheet protection is little more than protection
against accidental damage as it is very easily removed no matter what
password you may give.

See:
http://www.mcgimpsey.com/excel/removepwords.html

--
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.
 
Hi
try the following
- select all cells for which you want to allow entry
- goto 'Format - Cells - Protection' and uncheck 'Locked' for these
cells
- goto 'Tools - Protection' and protect your worksheet
 
Back
Top