Protect Sheet from Viewing of formulas

[reemt]

Hello,

does any one know how to protect a sheet from formulas viewing.. actually i have some cells in the sheets that i need to unlock them so that the user can have changes in them, and the rest of the cells of the sheet should be protected from viewing of their relative formulas. i tried to protect the sheet with the usual way, though it does half of the job of protection from changes in cells but the formulas are still showing.

thanks

 

[JamesW]

Hi,

Right click on the cell, click on Format Cells and goto the Protection tab. Select the 'Hidden' checkbox. When you next protect the sheet the formula will be hidden.