| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protecting formulae!
hi!
how can i protect my formulae in sharable xl workbooks..so that others can't alter by mistake? -via135 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
protecting formulae!
Unlock the dependent cells and lock the formula cell, then protect the
sheet. You lock/unlock a cell with Format - Cells - Protection tab - check or uncheck the "Locked" box. You can protect the sheet by Tools - Protect Sheet. HTH Otto "via135" wrote in message ups.com... hi! how can i protect my formulae in sharable xl workbooks..so that others can't alter by mistake? -via135 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
protecting formulae!
Note: any worksheets have to be protected before you set as a shared workbook.
Also, once shared you cannot unprotect the sheets without un-sharing the workbook. Gord Dibben MS Excel MVP On Thu, 2 Nov 2006 15:41:44 -0500, "Otto Moehrbach" wrote: Unlock the dependent cells and lock the formula cell, then protect the sheet. You lock/unlock a cell with Format - Cells - Protection tab - check or uncheck the "Locked" box. You can protect the sheet by Tools - Protect Sheet. HTH Otto "via135" wrote in message oups.com... hi! how can i protect my formulae in sharable xl workbooks..so that others can't alter by mistake? -via135 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
protecting formulae!
thks for Gord..!
for the information.! -via135 Gord Dibben wrote: Note: any worksheets have to be protected before you set as a shared workbook. Also, once shared you cannot unprotect the sheets without un-sharing the workbook. Gord Dibben MS Excel MVP On Thu, 2 Nov 2006 15:41:44 -0500, "Otto Moehrbach" wrote: Unlock the dependent cells and lock the formula cell, then protect the sheet. You lock/unlock a cell with Format - Cells - Protection tab - check or uncheck the "Locked" box. You can protect the sheet by Tools - Protect Sheet. HTH Otto "via135" wrote in message oups.com... hi! how can i protect my formulae in sharable xl workbooks..so that others can't alter by mistake? -via135 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
protecting formulae!
thks Gord.!
for the information..! -via135 Gord Dibben wrote: Note: any worksheets have to be protected before you set as a shared workbook. Also, once shared you cannot unprotect the sheets without un-sharing the workbook. Gord Dibben MS Excel MVP On Thu, 2 Nov 2006 15:41:44 -0500, "Otto Moehrbach" wrote: Unlock the dependent cells and lock the formula cell, then protect the sheet. You lock/unlock a cell with Format - Cells - Protection tab - check or uncheck the "Locked" box. You can protect the sheet by Tools - Protect Sheet. HTH Otto "via135" wrote in message oups.com... hi! how can i protect my formulae in sharable xl workbooks..so that others can't alter by mistake? -via135 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
protecting formulae!
"via135" ने लिखा: hi! how can i protect my formulae in sharable xl workbooks..so that others can't alter by mistake? -via135 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: 'always choose same cell' symbol for use in formulae | Excel Discussion (Misc queries) | |||
| Recalculation of formulae disabled | Excel Discussion (Misc queries) | |||
| Change to formulae | Excel Worksheet Functions | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
| Dynamic formulae - similar to lotus 123 for excel | Excel Discussion (Misc queries) | |||
Linear Mode
