I have two users that each needs to review/edit a seperate range in the same
sheet. When review/edit is completed each user should be able to protect
their own range. Any idea how to set up two independently protected ranges -
using independent passwords?

Any help is highly appreciated!
The doctor

This will probably take some VB code to control. Can you give us some more
details? For example, what are the two ranges? Are they fixed or variable?
Will the workbook *always* be closed when a user is finished with it? Are
the two users *always* on their own computers when using the spreadsheet; or
if on the same computer, will they *always* be logged into Windows using
their own personal logins? I'm thinking with this latter question that you
may not have to maintain separate passwords if the users login into Windows
individually (we can just ask Windows what the user's UserName is)?

--
Rick (MVP - Excel)



"Dr. Schwartz" wrote in message
...
I have two users that each needs to review/edit a seperate range in the
same
sheet. When review/edit is completed each user should be able to protect
their own range. Any idea how to set up two independently protected
ranges -
using independent passwords?

Any help is highly appreciated!
The doctor

Actually the 1st range is the whole sheet and the 2nd is a fixed range (eg
B1:B10) within that sheet.

Maybe a workflow describes better what i want:

User 1 (administrator):
- Opens the file
- Unlocks the sheet with password 1
- Edits in the entire sheet
- Locks the sheet with password 1
- Save & close the file.

User 2 (super user):
- Opens the file
- Unlocks range B1:B10 ONLY! using password 2
- Edits in range B1:B10
- Locks range B1:B10 with password 2
- Save & close the file.

Hope this can generate ideas for a solution.


"Rick Rothstein" skrev:

This will probably take some VB code to control. Can you give us some more
details? For example, what are the two ranges? Are they fixed or variable?
Will the workbook *always* be closed when a user is finished with it? Are
the two users *always* on their own computers when using the spreadsheet; or
if on the same computer, will they *always* be logged into Windows using
their own personal logins? I'm thinking with this latter question that you
may not have to maintain separate passwords if the users login into Windows
individually (we can just ask Windows what the user's UserName is)?

--
Rick (MVP - Excel)



"Dr. Schwartz" wrote in message
...
I have two users that each needs to review/edit a seperate range in the
same
sheet. When review/edit is completed each user should be able to protect
their own range. Any idea how to set up two independently protected
ranges -
using independent passwords?

Any help is highly appreciated!
The doctor

.

If you are on a Windows domain, then Tools-Protection-'Allow users to
edit ranges' may be what you are after.


Dr. Schwartz;692563 Wrote:

I have two users that each needs to review/edit a seperate range in the
same
sheet. When review/edit is completed each user should be able to
protect
their own range. Any idea how to set up two independently protected
ranges -
using independent passwords?

Any help is highly appreciated!
The doctor


--
aflatoon

Regards,
A.
------------------------------------------------------------------------
aflatoon's Profile: 1501
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=193606

http://www.thecodecage.com/forumz

No - as far as i can tell this functionality leaves no posibility to lock the
range afterwards.

"aflatoon" skrev:


If you are on a Windows domain, then Tools-Protection-'Allow users to
edit ranges' may be what you are after.



Dr. Schwartz;692563 Wrote:

I have two users that each needs to review/edit a seperate range in the
same
sheet. When review/edit is completed each user should be able to
protect
their own range. Any idea how to set up two independently protected
ranges -
using independent passwords?

Any help is highly appreciated!
The doctor


--
aflatoon

Regards,
A.
------------------------------------------------------------------------
aflatoon's Profile: 1501
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=193606

http://www.thecodecage.com/forumz

.