protecting formulae!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

via135 - 02 Nov 2006 17:32 GMT

hi!

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

-via135

Reply to this Message

Otto Moehrbach - 02 Nov 2006 21:41 GMT

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

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

Reply to this Message

Gord Dibben - 02 Nov 2006 23:04 GMT

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

>Unlock the dependent cells and lock the formula cell, then protect the
>sheet.
[quoted text clipped - 7 lines]
>>
>> -via135

Reply to this Message

via135 - 03 Nov 2006 18:45 GMT

thks for Gord..!
for the information.!

-via135

> Note: any worksheets have to be protected before you set as a shared workbook.
>
[quoted text clipped - 14 lines]
> >>
> >> -via135

Reply to this Message

via135 - 03 Nov 2006 18:47 GMT

thks Gord.!
for the information..!
-via135

> Note: any worksheets have to be protected before you set as a shared workbook.
>
[quoted text clipped - 14 lines]
> >>
> >> -via135

Reply to this Message

BK Ashok Kumar - 09 Nov 2006 06:38 GMT

"via135" ने लिखा:

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

Reply to this Message