|
Posted to microsoft.public.excel.programming
|
|
|
show value but hide function
Thanks!
Craig_Richards wrote:
Hello
There is a way indeed. You need to use the Tools/Protection/Protect
sheet (or workbook) option. This will then prevent anyone changing
anything.
In order to hide the formulae you need to select the cell in question
and under the Format/Cells/Protection select "hidden". This means that
when you protect the worksheet the formula will be hidden. Even though
it is invisible it can still be deleted so you shoudl also check the
"locked" option next to the "hidden" option and then people will not be
able to change anything either.
By default, every cell is set up with "Locked" in a speadsheet so that
when you activate protection nothing may be changed. If you need to
allow input into certain cells by the user then you should select those
cells and uncheck the "locked" option. Of course if you want someone to
be able to enter in more cells than not then you can select the whole
sheet, deselect "locked" for everything and then simply reselct
"locked" for the few cells in question.
Clear?
Good luck
--
Craig_Richards
------------------------------------------------------------------------
Craig_Richards's Profile: http://www.excelforum.com/member.php...o&userid=21936
View this thread: http://www.excelforum.com/showthread...hreadid=565180
|