Hiding Formula's

Hi

In Excel is it possible to hide or lock a formula e.g. =IF(A2=Rate_30,A2,"")
so members of staff don't mess with it or delete it by accident - often
have to Sort the sheet during business hours - so have tried sheet protection
and locking and
hiding this is a bit cumbersome is there anything easier and quicker.

Mully

Two step process:
1) select the cells that you want to be available to users to enter data;
use Format|Cells, open Protection tab and uncheck the Locked box
2) Use Tools|Protection and protect the sheet. Since your aim is to prevent
accidents, do not bother with password or use one that will be very easily
recalled by you

If the cells in (1) are not in a contiguous range, click on one and hold
down the CTRL key while clicking on each of the rest. This lets you select
all the cell and speeds up the work

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"mully" <mully@discussions.microsoft.com> wrote in message
news:8FE7A298-C646-4AF8-B98C-62C7C4555377@microsoft.com...
>
> Hi
>
> In Excel is it possible to hide or lock a formula e.g.
> =IF(A2=Rate_30,A2,"")
> so members of staff don't mess with it or delete it by accident - often
> have to Sort the sheet during business hours - so have tried sheet
> protection
> and locking and
> hiding this is a bit cumbersome is there anything easier and quicker.
>
> Mully
>

Hi

Thanks for the answer going to use an easy to remember password and followed
your suggestions it works ok.

Thanks for your help

Regards Mully

"Bernard Liengme" wrote:

> Two step process:
> 1) select the cells that you want to be available to users to enter data;
> use Format|Cells, open Protection tab and uncheck the Locked box
> 2) Use Tools|Protection and protect the sheet. Since your aim is to prevent
> accidents, do not bother with password or use one that will be very easily
> recalled by you
>
> If the cells in (1) are not in a contiguous range, click on one and hold
> down the CTRL key while clicking on each of the rest. This lets you select
> all the cell and speeds up the work
>
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "mully" <mully@discussions.microsoft.com> wrote in message
> news:8FE7A298-C646-4AF8-B98C-62C7C4555377@microsoft.com...
> >
> > Hi
> >
> > In Excel is it possible to hide or lock a formula e.g.
> > =IF(A2=Rate_30,A2,"")
> > so members of staff don't mess with it or delete it by accident - often
> > have to Sort the sheet during business hours - so have tried sheet
> > protection
> > and locking and
> > hiding this is a bit cumbersome is there anything easier and quicker.
> >
> > Mully
> >
>
>
>