restriction

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working on segments of data from within a list 1
restrict users to input atleast five characters 3
Summing Percentages 3
Random selection of records based on specifc value 5
Data validation, mandatory and restricted field length for excel vbs 10
formulas not auto calculating and will not calculate 8
File sharing 6
Loading Data into an Array 1

Back
Top