"Norman Harker" wrote in message
...
Hi Mark!
What you want to do can probably be achieved with a moderate degree of
difficulty.
But why not make it easier. Put the different ranges on different
sheets and protect those sheets with different passwords. If there are
reasons why you want the data to be together, then have a third sheet
that brings in the data from the separate sheets. All that and no
macros needed.
But worksheet protection is easily circumvented so this, like any
other solution, is not foolproof.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Thanks for the RE Norman! I worked it out using the "Allow users to edit
ranges" option. One password for each of the two user ranges and one for
the master. Works fine now. Thanks.