Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I want to hide the formula's which I have done, so that no one ca.
I want to hide the formula's which I have done, so that no one can see, but
they can edit the same sheet or workbook |
#2
|
|||
|
|||
You will need to unlock the cells you want people to change and lock and
hide the ones with your formulas, format, cells, protection, then protect the worksheet, tools, protection, protect sheet. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Excel General Question" <Excel General wrote in message ... I want to hide the formula's which I have done, so that no one can see, but they can edit the same sheet or workbook |
#3
|
|||
|
|||
If you want the user to be able to edit the worksheet, they'll have
access to the formulae. There's no way to prevent that. Even if you protect the worksheet so that the formulae are hidden, anyone who can find these groups can find ways to bypass the protection in a few seconds: http://www.mcgimpsey.com/excel/removepwords.html In article , "Excel General Question" <Excel General wrote: I want to hide the formula's which I have done, so that no one can see, but they can edit the same sheet or workbook |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |