| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting formulas in a workbook | Excel Worksheet Functions | |||
| Can I use formulas that return cell range ref. in charts X series | Charts and Charting in Excel | |||
| Copy range of cells omitting formulas that result in " " | Excel Discussion (Misc queries) | |||
| Formula Changes when data entered in referenced range | Excel Discussion (Misc queries) | |||
| How do I modify range of cells viewed in HTML format? | Excel Discussion (Misc queries) | |||
Threaded Mode
