how to cover the formula

[Guest]

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

 

[Guest]

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

 

[Guest]

Ron,

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

 

[Biff]

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

 

[Rowan Drummond]

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

Regards
Rowan

 

[Desert Piranha]

Hi Rowan,
Yeah, you are correct. The cell still has to be hidden, through
Format>Protection>Hidden.
Sorry for any confusion.
Dave

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

Regards
Rowan

 

[Desert Piranha]

hi,

could anyone tell me how to cover the formula in the column, so tha
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 thre
semicolons.
Format>Cells>Custom> key in ;;; click Ok
Then protect the sheet

 

[Gord Dibben]

Lawrence

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


Gord Dibben Excel MVP