It is a 2-stage process, it is just a question of getting the hang of it.

Use the format/protection command and make sure you have the settings
correct for all the worksheet - that in itself hasn't enabled anything -
just set the criteria for the cells.

Then you need to enable it. On XP it is Tools/Protection/Protect sheet,
etc. - there you have all the options in terms of what you will allow/not
allow users to do.

You also have the option of hiding columns and rows before you apply the
protection and that then locks them out of view once protection is enabled.

It /will/ work unless I've missed something. Have you thought about trying
it out on a simple worksheet to see how it works in practice. (It isn't the
easiest feature to see working until you get the hang of it.)

Rob


"vlook fomula" wrote in message
...
Dear Sir,
i applied your given instructions (choose Format/Protection. Your options
are there.)
i could not get any sucess and there. secondly i can protect hole
worksheet
now but i cant get sucess to protect specific area of a sheet. kidly do
the
need full?
"RFJ" wrote:

Highlight the cells you want to protect, right click the mouse button and
choose Format/Protection. Your options are there.

From the main menu*, you then have the option of protecting the whole
workbook or worksheet. That enables the protection you put on in the
format
command

In OL2007 it is Review/ and your options are on the ribbon bar.

"vlook fomula" wrote in message
...
my question is " how i can protect a spacific area of a worksheet?
either
few
cells, rows or few coloumns?