Excel's protection is made to protect intellectual property. It's made to stop
users from overwriting cells.
If you put something into a workbook and share it with others, then you won't be
able to stop the dedicated from seeing all that stuff.
You can lock the cells (format|cells|Protection tab) and hide the formulas (on
that same tab), then protect the worksheet (tools|Protection|protect sheet), but
this protection can be broken in moments.
If you don't want others to see stuff, don't put it in excel--or don't share
that excel workbook.
Andrew Heath wrote:
Hi, I have a .xls with 15 worksheets.
It consists of 9 sheets containing Bill of Materials and pricing for an
individual project.
I need to hide a range of formulas on each sheet so that my client cannot
view the formula (the formula contains sensitive pricing lookups)
I am happy for the customer view the formula result in this range and to
play around and see/edit anything else.
I need to switch this on and off as I send out each version.
Workbook protection is too severe and client cannot do anything.
pls help!
--
Brisbane, QLD
Australia
--
Dave Peterson
|