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

--
Message posted via http://www.officekb.com

Check out

Tools | Protection | Allow Users to Edit Ranges
--
HTH...

Jim Thomlinson


"Kelly_Durden via OfficeKB.com" wrote:

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

--
Message posted via http://www.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

Jim Thomlinson wrote:
Check out

Tools | Protection | Allow Users to Edit Ranges
Hello,

[quoted text clipped - 11 lines]
Thanks in advance.
Kelly

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201002/1

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

With those selected go to InsertNameDefine 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

On Wed, 10 Feb 2010 20:52:38 GMT, "Kelly_Durden via OfficeKB.com"
<u41001@uwe wrote:

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

Jim Thomlinson wrote:
Check out

Tools | Protection | Allow Users to Edit Ranges
Hello,

[quoted text clipped - 11 lines]
Thanks in advance.
Kelly

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

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

With those selected go to InsertNameDefine 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]
Thanks in advance.
Kelly

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201002/1