hide and protect formula?

[needhelp2]

Hi!!
I want to hide and protect me formula to edit.infect i want that if some one work on me sheet he cant see my formula and past data on cells

Please assist me in this regard.



Hi!!
I want to hide and protect me formula to edit.infect i want that if some one work on my sheet he cant see my formula and he cant paste data on cells

Please assist me in this regard.

 

[c_m_s_jr]

Use the "Locked" and "Hidden" checkboxes found under the "Protection" tab of Formate cells.

If the box is checked for "Locked", when the spreadsheet is protected then the cell contents can't be changed.

If the box is checked for "Hidden, when the spreadsheet is protected then the cell formula's can't be seen.

 

[needhelp2]

that's great.Love you .
I know one thing more that i am using buttons in my sheet.i enter there code from view code, and save,
!!! when ever i close and reopen sheet my macros are not avalible in sheet how i can fix it?