Protecting a sheet partly in Excel 2003

[Dr. Schwartz]

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

 

[Rick Rothstein]

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)?

 

[Dr. Schwartz]

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:

 

[Dr. Schwartz]

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

"aflatoon" skrev: