Protect excel worksheet
Hi
I would like to protect excel worksheet such that user should able to select the cell but he should not able to see the forumla which i have entered in that cell
Thanks in advance
Suhas
Last edited by suhas.nehete; 09-23-2011 at 03:07 AM.
right click on the cell with formula
choose format cell
then protection tab
click the 2 check boxes lock, hidden
lastly protect the worksheet or sheet
right click on cells go to Format Cells / Protection then put a check in hidden then protect your worksheet
Thanks for quick reply
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks