DEAR ALL

I have a protected worksheet where various departments have to enter the data.

What I need is to release the respective named ranges to the respective
departments to make data entry.

One way I thought was to restrict the scroll area and give a command button
to unprotect. But there is room for mischief as other dept can unprotect and
change the data. Also thought of giving passwords and getting users input
from input box and release the sheet. But unable to assign password for
particular named range.

So if the sheet is protected, and if Charlie has to change data in the named
range charlie_range, how can I provide an indiviudal password to Charlie and
like wise to each dept for their named range. Hope I got my need explained.

Can anyone suggest / help me pls?

brgds/captgnvr