Best way??-one WB, many users entering only their own info
 

Here's what they want: About 35 people need to enter info into a
spreadsheet. Each user needs to see only their own information.
Admin, though, wants to be able to see everyone's info.

Some possible solutions:
(1) Each user has their own workbook; they have a password that
allows only them to open it. Admin has their own workbook, and each
individual user's workbook is linked back into Admin's so each user's
data shows up there.
(2) One workbook with one sheet per user and one for Admin.
Another sheet holds username and passwords. On open, user is
presented with a form asking for username and password; only that
user's page will show, all others are VeryHidden.

Which way would work best? Or is there a better way?

Ed

Best way??-one WB, many users entering only their own info
 

If the data is really important and shouldn't bee seen by others, then there's
no way to insure that #2 will work.

Your choice is down to #1 or using a different application--one that supports
this kind of security.

Well, you could have 35 different workbooks and one workbook that opened all the
others and did copy|pasting to get a consolidated list of data.



Ed wrote:

Here's what they want: About 35 people need to enter info into a
spreadsheet. Each user needs to see only their own information.
Admin, though, wants to be able to see everyone's info.

Some possible solutions:
(1) Each user has their own workbook; they have a password that
allows only them to open it. Admin has their own workbook, and each
individual user's workbook is linked back into Admin's so each user's
data shows up there.
(2) One workbook with one sheet per user and one for Admin.
Another sheet holds username and passwords. On open, user is
presented with a form asking for username and password; only that
user's page will show, all others are VeryHidden.

Which way would work best? Or is there a better way?

Ed

--

Dave Peterson

Best way??-one WB, many users entering only their own info
 

Thanks, Dave. I was hoping to get away with only one workbook, but I
don't guess I will this time.

Ed

On Apr 12, 1:13 pm, Dave Peterson wrote:
If the data is really important and shouldn't bee seen by others, then there's
no way to insure that #2 will work.

Your choice is down to #1 or using a different application--one that supports
this kind of security.

Well, you could have 35 different workbooks and one workbook that opened all the
others and did copy|pasting to get a consolidated list of data.


Dave Peterson- Hide quoted text -