Hide formula in formula bar without protecting cell

[niteshmech1]

Dear all
I want to hide the formula to display in formula bar without protecting sheets.I just no one can copy may formula which I discovered after hard work but at same time I also don't to protect sheet otherwise no one able to work.

Please help me !!!

Nitesh

 

[sark666]

Afaik, you can't really do what you're after without protecting the sheets. However, I'm not sure if you realize all cells are locked by default, it's just that the sheet itself is not protected by default.

So for the cells where you want the user to be able to input data, right click on the cell, choose the protection tab, and uncheck 'locked'. Then when you protect the sheet, those cells will still be editable.

 

[niteshmech1]

Thanks....will try and come again if find any problem