| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Locking Excel cells
I created a set of documents with Excel in which users can enter data into
cells in an "InputSheet" (sheet 1) which will populate to several other "recipient template documents" (Sheets 2, 3, 4 etc.). How can I lock the template sheets so that users can not modify them in any way but by entering data in the InputSheet? -- Sue |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Locking Excel cells
You have one workbook with multiple worksheets?
The populating is done by linked formulas back to "Inputsheet"? Just lock all cells on sheets 2, 3 and 4 and Protect those sheets under ToolsProtection. Formulas will update but users cannot manually change anything on those sheets. Gord Dibben MS Excel MVP On Fri, 23 Jan 2009 11:22:01 -0800, SueCoach wrote: I created a set of documents with Excel in which users can enter data into cells in an "InputSheet" (sheet 1) which will populate to several other "recipient template documents" (Sheets 2, 3, 4 etc.). How can I lock the template sheets so that users can not modify them in any way but by entering data in the InputSheet? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Locking Excel cells
Yes, you understood my question and answered it perfectly! I've done a lot
of docs in Word Developer, but the process is different. Thanks! -- Sue "Gord Dibben" wrote: You have one workbook with multiple worksheets? The populating is done by linked formulas back to "Inputsheet"? Just lock all cells on sheets 2, 3 and 4 and Protect those sheets under ToolsProtection. Formulas will update but users cannot manually change anything on those sheets. Gord Dibben MS Excel MVP On Fri, 23 Jan 2009 11:22:01 -0800, SueCoach wrote: I created a set of documents with Excel in which users can enter data into cells in an "InputSheet" (sheet 1) which will populate to several other "recipient template documents" (Sheets 2, 3, 4 etc.). How can I lock the template sheets so that users can not modify them in any way but by entering data in the InputSheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - locking cells | Charts and Charting in Excel | |||
| Excel - randomly locking cells? | Excel Discussion (Misc queries) | |||
| locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
| Locking cells in Microsoft Excel | Excel Worksheet Functions | |||
| How can I unlock the grouping in Excel while locking cells? | Excel Discussion (Misc queries) | |||
Linear Mode
