protecting formulae!
 

hi!

how can i protect my formulae in sharable xl
workbooks..so that others can't alter by mistake?

-via135

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

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

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

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

protecting formulae!
 

"via135" ने लिखा:

hi!

how can i protect my formulae in sharable xl
workbooks..so that others can't alter by mistake?

-via135