Anna

Thanks for your reply. The problem with that is that the formulas need to
work as the customer will try modelling changes. On each sheet there is only
one column of formulas that I don't want them to be able to see.
I would do what you said however this would take 10-20 minutes each day and
would kill the customers ability to model quantity changes.

Regards

Andrew 'The Ox' Heath
Brisbane, QLD
Australia


"Anne Troy" wrote:

You'll be far better off if you first turn the formulas into values, and
then save "this worksheet" into a new workbook, and send THAT instead of
sending your "calculating" workbook (which you would close without saving).
For instance, a macro like this could help you:
http://vbaexpress.com/kb/getarticle.php?kb_id=377
************
Anne Troy
www.OfficeArticles.com

"Andrew Heath" (delete) wrote in message
...
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