View Single Post
  #1   Report Post  
Andrew Heath
 
Posts: n/a
Default Protecting Formulas from a range from being viewed

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