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
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
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 [email protected]>
wrote in message news:[email protected]...
> 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
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 <[email protected]>,
"Excel General Question" <Excel General
[email protected]> 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
A follow up on sheet protection. As my father always said, "A lock only stops an honest man."
You must know your audience. If you fear malicious (or at least intentional) alteration to your formulae, you would be better off putting all calculations on a hidden sheet and password protecting that. Still not perfect, but more secure than other options.
Good Luck.
Bruce
The older I get, the better I used to be.
USA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks