Home |
Search |
Today's Posts |
#1
|
|||
|
|||
share a workbook but protect the formulas
I need to share workbooks but protect all the formulas while still allowing
our clients to enter data. |
#2
|
|||
|
|||
Protect the sheet
Use- Tools Protection Protect Sheet, you can enter a password This will protect all cells in the worksheet, as all the cells are formatted to be locked. To select all the non-formula cells use <edit<go to<special<select constants. then Format Cells Protection Tab and uncheck the locked selection. -- Greetings from New Zealand Bill K "clemrogan" wrote in message ... I need to share workbooks but protect all the formulas while still allowing our clients to enter data. |
#3
|
|||
|
|||
You can lock (or unlock) cells via Format|cells|protection tab
On that tab, check the Hidden box to hide the formula--but you need to protect the worksheet to take effect (tools|Protection|protect sheet) Be aware that worksheet protection is pretty darn simple to break. clemrogan wrote: I need to share workbooks but protect all the formulas while still allowing our clients to enter data. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting formulas in a workbook | Excel Worksheet Functions | |||
How do I protect only formulas in Excel? | Excel Discussion (Misc queries) | |||
How Do I Share an Excel Workbook on line with 3 others? | Excel Discussion (Misc queries) | |||
i want to share a workbook, but not all of the worksheets. | Excel Worksheet Functions | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) |