how to cover the formula

L

Lawrence

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
 
R

Ron Coderre

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
 
L

Lawrence

Ron,

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

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
 
R

Rowan Drummond

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

Regards
Rowan
 
D

Desert Piranha

Hi Rowan,
Yeah, you are correct. The cell still has to be hidden, through
Format>Protection>Hidden.
Sorry for any confusion.
Dave
Rowan said:
That would hide the result but the formula would still be visible in
the
formula bar.

Regards
Rowan
Click to expand...
 
D

Desert Piranha

Lawrence said:
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,
Click to expand...
Another way is custom format the cells with ;;; that is thre
semicolons.
Format>Cells>Custom> key in ;;; click Ok
Then protect the sheet
 
G

Gord Dibben

Lawrence

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


Gord Dibben Excel MVP
 
Top