Hiding a Formula

[mmmarks]

Hi All,

I have an query regarding Hiding a formula.
My query is : I have created a formula in a cell But I don't want to display in formula Bar But Still It should be excutable.
More clear,
In A1, 10
In B1, 20 Adding Both In C1
By formula =Sum(A1:b1).
I dont want to display above formula to anyone but A1 and B1 can be changed by anyone.
Hope You all are Understood.

 

[Akashwani]

Hi,

I think that you will need to Protect your worksheet.
Click the top left of your sheet between 1 & A.
Right click, Format Cells, Protection, Check Locked, Check Hidden, click Ok.
Now highlight the cells you want the users to have access to.
Right click, Format Cells, Protection, Unheck Locked.
Now protect your worksheet with a password (that you wont forget )

I hope that works.

Ak

 

[mmmarks]

AwesUm Logic
Thanks... I have done it.

 

[Akashwani]

Great, thanks for the feed back.

Ak