Multi-User Access to a worksheet

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

My tools to use are limited and generally speaking I know
Excel wouldn't be used like this but I don't have any
other choice.

Here's the scenario: I have a worksheet full of rows that
need to be worked individually. I have 42 people that
will need to access this worksheet to retrieve one row at
a time. When they receive that row, the row needs to be
updated with that person's name and that row cannot be
accessed again by subsequent users.

I'm interested in proposals on how to do this? Namely
building a front end and learning about shared workbooks
and their limitations. The help file has finally let me
down.

Any insight would be greatly appreciated.

TIA.

-Brad
 
If accessing a row means changing its cells contents, then I can think of 2
ways, both require a column for storing the user name.

1. presents the info of the row in a form, user selects target row form
listbox/combobox and change info in textboxes, updates the info with a
button, you can ID the user with application.username & display that on the
form, you can protect the worksheet so user can't change it without using
the form, you may only show the rows that are allowed to be accessed in the
listbox, you can add time & date of accessed in another column

2. use worksheet_change event, but this is a bit more complicated as you
need to take care of changes in multiple cells.

On the other hand, if accessing a row simply means reading the info, it's
not difficult to modify the form to do this in the first solution. I think
Excel can do what you want and can be used in whatever way you can think of
and very often in ways that I can never think of.
 
Back
Top