V
vlook fomula
my question is " how i can protect a spacific area of a worksheet? either few
cells, rows or few coloumns?
cells, rows or few coloumns?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
RFJ
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.
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.
V
vlook fomula
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?
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?
R
RFJ
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
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
D
DS-NTE
By default all cells are locked whwn you protect a sheet, you have to do it
this way:
Select all the cells you dont want to protect then choose Format/Protection,
uncheck "Locked", then protect your sheet.
hth
this way:
Select all the cells you dont want to protect then choose Format/Protection,
uncheck "Locked", then protect your sheet.
hth