Protect Sheet

[punit83]

Hello Every1.

1) I would like to ask that is there anyway other than macro to protect the sheet with password.
2) Also if i can hide the used formula.


For Example :-

1) I have all my main working data with infor in sheet1 and i am using the data with respective info in sheet2 & sheet3, people can have access to sheet2&3 but i want to protect sheet1 with paswword, now i am protecting by going view code and selecting very hidden.

2) in sheet2&3 i am fetching data from sheet1 with using types of formula, i want to protect sheet2&3 from others to view formula.


above both example i don't want to use macro.



thanks in advanced.

 

[baitmaster]

You want to protect a worksheet, without using VBA?

View > Protect Sheet

 

[punit83]

Thank you.


if want to protect with vba than pls let me know.

 

[jtakw]

Hi,

If you just want to "Protect", in other words, "Hide" the formulas from users, select the cells (or select the entire sheet), right click, click Format Cells, choose Protection tab, check "Hidden".

Edit: You might also want to make sure the "Locked" box is checked.