Restricting Edit Rights

[Kelly_Durden via OfficeKB.com]

Hello,

Does anyone know if there is a way that I can restrict who changes allocation
cells in the file I'm creating. For instance if Kelly Durden has been
assigned to allocate budget only Kelly Durden can edit those 4 lines and
change the budget?

Example of my file is

Kelly Durden Name Column R
i.e 4 Rows assigned to that BC
Column AF is the cell where the budget will be editable

Thanks in advance.
Kelly

 

[Jim Thomlinson]

Check out

Tools | Protection | Allow Users to Edit Ranges

 

[Kelly_Durden via OfficeKB.com]

Hi Jim

Thanks for this, but at a first glance I think it will only work if my cells
were in order to be able to create a range. My file has the Costing POC's in
multiple lines and not in order.

Kelly

Check out

Tools | Protection | Allow Users to Edit Ranges

Hello,

[quoted text clipped - 11 lines]

Thanks in advance.
Kelly

 

[Gord Dibben]

Select a range of cells by CTRL + Click on non-contiguous cells or rows.

With those selected go to Insert>Name>Define and give that range a name like
myname

When you go to Allow users to edit ranges simply click on New.

In the refers to: dialog enter =myname

That will also be the Title

Add a password then Apply and Protect Sheet.


Gord Dibben MS Excel MVP

Hi Jim

Thanks for this, but at a first glance I think it will only work if my cells
were in order to be able to create a range. My file has the Costing POC's in
multiple lines and not in order.

Kelly

Check out

Tools | Protection | Allow Users to Edit Ranges

Hello,

[quoted text clipped - 11 lines]

Thanks in advance.
Kelly

 

[Kelly_Durden via OfficeKB.com]

Hello,

Thanks for your help, I filter on one name highlighted the cells but the
ransge included the un-filted names as well - what am I doing wrong?

Kind regards
Kelly

Select a range of cells by CTRL + Click on non-contiguous cells or rows.

With those selected go to Insert>Name>Define and give that range a name like
myname

When you go to Allow users to edit ranges simply click on New.

In the refers to: dialog enter =myname

That will also be the Title

Add a password then Apply and Protect Sheet.

Gord Dibben MS Excel MVP

Hi Jim

[quoted text clipped - 12 lines]