how to cover the formula

hi,


could anyone tell me how to cover the formula in the column, so that people
unable see what the formula i have put in.

thanks in advance...

Lawrence

Have you tried :
Format>Cells>Protection
Checked: Locked and Hidden

When you protect the sheet, users won't be able to see the formula or change
it.

Does that help?

***********
Regards,
Ron


"Lawrence" wrote:

> hi,
>
>
> could anyone tell me how to cover the formula in the column, so that people
> unable see what the formula i have put in.
>
> thanks in advance...
>
> Lawrence

Ron,

i couldn't find the Locked and hidden... i just able to see the Protection
only...

"Ron Coderre" wrote:

> Have you tried :
> Format>Cells>Protection
> Checked: Locked and Hidden
>
> When you protect the sheet, users won't be able to see the formula or change
> it.
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
>
> "Lawrence" wrote:
>
> > hi,
> >
> >
> > could anyone tell me how to cover the formula in the column, so that people
> > unable see what the formula i have put in.
> >
> > thanks in advance...
> >
> > Lawrence

Hi!

Try this:

Hit CTRL A
Goto Format>Cells>Protection tab
Uncheck Locked
OK

Now, select the cells with the formulas that you want protected.
Goto Format>Cells>Protection tab
Check Locked
Check Hidden
OK

Now, protect the sheet
Goto Tools>Protection>Protect sheet.

Depending on which version of Excel you are using, there are various options
for protection. Choose the ones you want .

Biff

"Lawrence" <[email protected]> wrote in message
news:[email protected]...
> Ron,
>
> i couldn't find the Locked and hidden... i just able to see the Protection
> only...
>
> "Ron Coderre" wrote:
>
>> Have you tried :
>> Format>Cells>Protection
>> Checked: Locked and Hidden
>>
>> When you protect the sheet, users won't be able to see the formula or
>> change
>> it.
>>
>> Does that help?
>>
>> ***********
>> Regards,
>> Ron
>>
>>
>> "Lawrence" wrote:
>>
>> > hi,
>> >
>> >
>> > could anyone tell me how to cover the formula in the column, so that
>> > people
>> > unable see what the formula i have put in.
>> >
>> > thanks in advance...
>> >
>> > Lawrence

That would hide the result but the formula would still be visible in the
formula bar.

Regards
Rowan

Desert Piranha wrote:
> Lawrence Wrote:
>
>>hi,
>>
>>could anyone tell me how to cover the formula in the column, so that
>>people
>>unable see what the formula i have put in.
>>
>>thanks in advance...
>>
>>LawrenceHi Lawrence,
>
> Another way is custom format the cells with ;;; that is three
> semicolons.
> Format>Cells>Custom> key in ;;; click Ok
> Then protect the sheet.
>
>

Lawrence

Did you click on the Format>Cells>Protection tab to get a list of options?


Gord Dibben Excel MVP

On Thu, 15 Dec 2005 19:16:02 -0800, "Lawrence"
<[email protected]> wrote:

>Ron,
>
>i couldn't find the Locked and hidden... i just able to see the Protection
>only...
>
>"Ron Coderre" wrote:
>
>> Have you tried :
>> Format>Cells>Protection
>> Checked: Locked and Hidden
>>
>> When you protect the sheet, users won't be able to see the formula or change
>> it.
>>
>> Does that help?
>>
>> ***********
>> Regards,
>> Ron
>>
>>
>> "Lawrence" wrote:
>>
>> > hi,
>> >
>> >
>> > could anyone tell me how to cover the formula in the column, so that people
>> > unable see what the formula i have put in.
>> >
>> > thanks in advance...
>> >
>> > Lawrence