I am able to lock complete worksheets so that they can not be changed but is
there any way that you can leave access to a certain amount of cells while
locking the rest, for example, those with formulas in them that react to
figures inserted by the user?
With the sheet not protected, use Format - Cells - Protection tab. Uncheck
"Locked" for those cells to be changeable. Now protect the sheet with
Tools - Protection - Protect sheet.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
"CrazyTony" <CrazyTony@discussions.microsoft.com> wrote in message
news:A74912EE-9091-4E44-B6F3-D55334680FC2@microsoft.com...
> I am able to lock complete worksheets so that they can not be changed but
is
> there any way that you can leave access to a certain amount of cells while
> locking the rest, for example, those with formulas in them that react to
> figures inserted by the user?
>
> many thanks.
Saw your post and want to ask on how to ungroup a group ranges when it's
protected? This is what i need to do, I have a bunch of tabs for each
department in one worksheet and i don't want unathorized employees reading
specific tabs unless they have the password for it. Once they are in that
tab, they need to ungroup the ranges and after that, they can only edit
specifc ranges and not all.
But unfortunately, i can only protect certain ranges if the worksheet is
protected without using the grouping and ungrouping the data, which means i
have to show confidential informations to other owner of tabs and it's just
that they can only read but not edit.
Is there a way that i can protect the sheet from unathorized reader? Or Is
there a way to unprotect the sheet so that users can use the group and group
function and yet can only edit specific ranges?
Thanks,
MJ
I would like to be able to do the same in excel. I came to the conclusion I
need a true accounting database software package with a good report writer a
average finance/accounting professional user can use. That is the correct way
to manage security I real database. Excel is a poor Mans Database.
> Hi Earl,
>
> Saw your post and want to ask on how to ungroup a group ranges when it's
> protected? This is what i need to do, I have a bunch of tabs for each
> department in one worksheet and i don't want unathorized employees reading
> specific tabs unless they have the password for it. Once they are in that
> tab, they need to ungroup the ranges and after that, they can only edit
> specifc ranges and not all.
> But unfortunately, i can only protect certain ranges if the worksheet is
> protected without using the grouping and ungrouping the data, which means i
> have to show confidential informations to other owner of tabs and it's just
> that they can only read but not edit.
> Is there a way that i can protect the sheet from unathorized reader? Or Is
> there a way to unprotect the sheet so that users can use the group and group
> function and yet can only edit specific ranges?
> Thanks,
> MJ
I used your instructions below but it removed the formating options for the
rest of the worksheet. This is important since I track changes in red font.
Is there anyway to protect a column of cells, per your instructions below
without the formating options for the rest of the worksheet going away?
"Earl Kiosterud" wrote:
> Tony,
>
> With the sheet not protected, use Format - Cells - Protection tab. Uncheck
> "Locked" for those cells to be changeable. Now protect the sheet with
> Tools - Protection - Protect sheet.
>
> --
> Earl Kiosterud
> mvpearl omitthisword at verizon period net
> -------------------------------------------
>
> "CrazyTony" <CrazyTony@discussions.microsoft.com> wrote in message
> news:A74912EE-9091-4E44-B6F3-D55334680FC2@microsoft.com...
> > I am able to lock complete worksheets so that they can not be changed but
> is
> > there any way that you can leave access to a certain amount of cells while
> > locking the rest, for example, those with formulas in them that react to
> > figures inserted by the user?
> >
> > many thanks.
>
>
>
When enabling the worksheet protection, checkmark allow users to format
cells.
Gord Dibben MS Excel MVP
On Fri, 20 Feb 2009 07:42:07 -0800, Janet <Janet@discussions.microsoft.com>
wrote:
>I used your instructions below but it removed the formating options for the
>rest of the worksheet. This is important since I track changes in red font.
>Is there anyway to protect a column of cells, per your instructions below
>without the formating options for the rest of the worksheet going away?
>
>"Earl Kiosterud" wrote:
>
>> Tony,
>>
>> With the sheet not protected, use Format - Cells - Protection tab. Uncheck
>> "Locked" for those cells to be changeable. Now protect the sheet with
>> Tools - Protection - Protect sheet.
>>
>> --
>> Earl Kiosterud
>> mvpearl omitthisword at verizon period net
>> -------------------------------------------
>>
>> "CrazyTony" <CrazyTony@discussions.microsoft.com> wrote in message
>> news:A74912EE-9091-4E44-B6F3-D55334680FC2@microsoft.com...
>> > I am able to lock complete worksheets so that they can not be changed but
>> is
>> > there any way that you can leave access to a certain amount of cells while
>> > locking the rest, for example, those with formulas in them that react to
>> > figures inserted by the user?
>> >
>> > many thanks.
>>
>>
>>
Each individual cell has a default format of locked that only comes into effect
when the sheet is protected. Simply format the cells and use the protection tab
to unlock the ones you want to access prior to protecting the sheet.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"CrazyTony" <CrazyTony@discussions.microsoft.com> wrote in message
news:A74912EE-9091-4E44-B6F3-D55334680FC2@microsoft.com...
>I am able to lock complete worksheets so that they can not be changed but is
> there any way that you can leave access to a certain amount of cells while
> locking the rest, for example, those with formulas in them that react to
> figures inserted by the user?
>
> many thanks.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004
Thank you Ken and Earl for the speedy replies. Amazingly simple once you know
what to do!!!
Mnay Thanks
Tony
"Ken Wright" wrote:
> Each individual cell has a default format of locked that only comes into effect
> when the sheet is protected. Simply format the cells and use the protection tab
> to unlock the ones you want to access prior to protecting the sheet.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
>
>
> "CrazyTony" <CrazyTony@discussions.microsoft.com> wrote in message
> news:A74912EE-9091-4E44-B6F3-D55334680FC2@microsoft.com...
> >I am able to lock complete worksheets so that they can not be changed but is
> > there any way that you can leave access to a certain amount of cells while
> > locking the rest, for example, those with formulas in them that react to
> > figures inserted by the user?
> >
> > many thanks.
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004
>
>
>
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"CrazyTony" <CrazyTony@discussions.microsoft.com> wrote in message
news:BB1DE13B-4102-44FB-A323-2F5B3A8F327C@microsoft.com...
> Thank you Ken and Earl for the speedy replies. Amazingly simple once you know
> what to do!!!
>
> Mnay Thanks
>
> Tony
>
>
> "Ken Wright" wrote:
>
>> Each individual cell has a default format of locked that only comes into
>> effect
>> when the sheet is protected. Simply format the cells and use the protection
>> tab
>> to unlock the ones you want to access prior to protecting the sheet.
>>
>> --
>> Regards
>> Ken....................... Microsoft MVP - Excel
>> Sys Spec - Win XP Pro / XL 97/00/02/03
>>
>> ----------------------------------------------------------------------------
>> It's easier to beg forgiveness than ask permission :-)
>> ----------------------------------------------------------------------------
>>
>>
>>
>> "CrazyTony" <CrazyTony@discussions.microsoft.com> wrote in message
>> news:A74912EE-9091-4E44-B6F3-D55334680FC2@microsoft.com...
>> >I am able to lock complete worksheets so that they can not be changed but is
>> > there any way that you can leave access to a certain amount of cells while
>> > locking the rest, for example, those with formulas in them that react to
>> > figures inserted by the user?
>> >
>> > many thanks.
>>
>>
>> ---
>> Outgoing mail is certified Virus Free.
>> Checked by AVG anti-virus system (http://www.grisoft.com).
>> Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004
>>
>>
>>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004
Question
Reply
Top
Answer
Notify me of replies