Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TTC delimiter restriction | Excel Discussion (Misc queries) | |||
Save-As Restriction | Excel Worksheet Functions | |||
VLOOKUP with a restriction | Excel Discussion (Misc queries) | |||
add restriction in Excel | Excel Worksheet Functions | |||
Textbox restriction | Excel Programming |