restriction
 

Hello,

Is it possible to allow multiple users to input data into one
spreadsheet/Excel file at the same time (shared file), and also restrict the
information that the users can see and update. Such as lines 25-100 I would
like one group to use and see, and lines 100-200 another group. I will also
need to prevent any changes from being made to columns B:E.

Thank You,

restriction
 

In xl2002+, you can allow users to edit certain ranges (each range can be
password protected and you share that range's protection with just the people
who should edit that range).

tools|protection|Allow users to edit ranges...

is where you'd find it.

In earlier versions, you might be able to mimic the behavior with worksheet
events. But those would depend on macros being enabled and if they weren't then
anyone could edit anything.



tjh wrote:

Hello,

Is it possible to allow multiple users to input data into one
spreadsheet/Excel file at the same time (shared file), and also restrict the
information that the users can see and update. Such as lines 25-100 I would
like one group to use and see, and lines 100-200 another group. I will also
need to prevent any changes from being made to columns B:E.

Thank You,

--

Dave Peterson