Good Evening Everyone !

I'm Miki and using Office 2k3 and is facing problem while using protection
in excel.

I have some formulas in my worksheet and I want that nobody can see the
formulas but they get only the values whatever is shown in the cell on
selecting the purticular cell !!!!

I know this is possible but I'm unaware of it !!!!

Can anybody guide me about that ???

Right click the cell and select Format Cells... - Protection tab and check
locked and hidden.
--
HTH...

Jim Thomlinson


"Miki" wrote:


Good Evening Everyone !

I'm Miki and using Office 2k3 and is facing problem while using protection
in excel.

I have some formulas in my worksheet and I want that nobody can see the
formulas but they get only the values whatever is shown in the cell on
selecting the purticular cell !!!!

I know this is possible but I'm unaware of it !!!!

Can anybody guide me about that ???

Hi Jim,

I have tried it but it's not working !!!!!!!!!!!

"Jim Thomlinson" wrote:

Right click the cell and select Format Cells... - Protection tab and check
locked and hidden.
--
HTH...

Jim Thomlinson


"Miki" wrote:


Good Evening Everyone !

I'm Miki and using Office 2k3 and is facing problem while using protection
in excel.

I have some formulas in my worksheet and I want that nobody can see the
formulas but they get only the values whatever is shown in the cell on
selecting the purticular cell !!!!

I know this is possible but I'm unaware of it !!!!

Can anybody guide me about that ???

Did you protect the worksheet after setting the cells?


Gord Dibben MS Excel MVP

On Wed, 20 Aug 2008 09:22:02 -0700, Miki
wrote:

Hi Jim,

I have tried it but it's not working !!!!!!!!!!!

"Jim Thomlinson" wrote:

Right click the cell and select Format Cells... - Protection tab and check
locked and hidden.
--
HTH...

Jim Thomlinson


"Miki" wrote:


Good Evening Everyone !

I'm Miki and using Office 2k3 and is facing problem while using protection
in excel.

I have some formulas in my worksheet and I want that nobody can see the
formulas but they get only the values whatever is shown in the cell on
selecting the purticular cell !!!!

I know this is possible but I'm unaware of it !!!!

Can anybody guide me about that ???

Yes I did but still it's not working.

I'm using excel 2003

It shows the formula instead of the value .....

"Gord Dibben" wrote:

Did you protect the worksheet after setting the cells?


Gord Dibben MS Excel MVP

On Wed, 20 Aug 2008 09:22:02 -0700, Miki
wrote:

Hi Jim,

I have tried it but it's not working !!!!!!!!!!!

"Jim Thomlinson" wrote:

Right click the cell and select Format Cells... - Protection tab and check
locked and hidden.
--
HTH...

Jim Thomlinson


"Miki" wrote:


Good Evening Everyone !

I'm Miki and using Office 2k3 and is facing problem while using protection
in excel.

I have some formulas in my worksheet and I want that nobody can see the
formulas but they get only the values whatever is shown in the cell on
selecting the purticular cell !!!!

I know this is possible but I'm unaware of it !!!!

Can anybody guide me about that ???

If you are seeing formulas in the cells but not in the formula bar because
you have hidden them, I would suggest you are in "Formula View".

Hit CTRL + `(backquote above Tab key) to toggle off.


Gord

On Sat, 23 Aug 2008 05:14:00 -0700, Miki
wrote:

Yes I did but still it's not working.

I'm using excel 2003

It shows the formula instead of the value .....

"Gord Dibben" wrote:

Did you protect the worksheet after setting the cells?


Gord Dibben MS Excel MVP

On Wed, 20 Aug 2008 09:22:02 -0700, Miki
wrote:

Hi Jim,

I have tried it but it's not working !!!!!!!!!!!

"Jim Thomlinson" wrote:

Right click the cell and select Format Cells... - Protection tab and check
locked and hidden.
--
HTH...

Jim Thomlinson


"Miki" wrote:


Good Evening Everyone !

I'm Miki and using Office 2k3 and is facing problem while using protection
in excel.

I have some formulas in my worksheet and I want that nobody can see the
formulas but they get only the values whatever is shown in the cell on
selecting the purticular cell !!!!

I know this is possible but I'm unaware of it !!!!

Can anybody guide me about that ???