Their code removes the sheet protection, which unlocks the ranges. Once
the sheet is unprotected, you can delete or modify the ranges, or set
new passwords.

There's some programming information he

Using the Protection Object to Protect Your Worksheets

http://msdn.microsoft.com/library/de...webProtSht.asp

Tom Ogilvy wrote:
Thanks Debra.

Done any testing/exploration on this with JE McGimpsey's/Norman Harker's
password breaking code?

--
Regards,
Tom Ogilvy

Debra Dalgleish wrote in message
...

There are instructions in the following MSKB article:

HOW TO: How to Apply Different Passwords or Permissions to Separate
Ranges in Worksheets in Excel 2002
http://support.microsoft.com/?kbid=289270

Dave Peterson wrote:

xl2002 added that feature.

Tools|Protection|Allow Users to Edit Ranges

"gulp!" wrote:

is it possible to protect different cells group of a sheet
with different password so that different users can have
possibility to modify only some cells and not others?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html