Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2007

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ed - 12 Apr 2007 20:52 GMT
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 - 12 Apr 2007 21:13 GMT
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.

> Here's what they want:  About 35 people need to enter info into a
> spreadsheet.  Each user needs to see only their own information.
[quoted text clipped - 13 lines]
>
> Ed

Signature

Dave Peterson

Ed - 12 Apr 2007 22:32 GMT
Thanks, Dave.  I was hoping to get away with only one workbook, but I
don't guess I will this time.

Ed

> If the data is really important and shouldn't bee seen by others, then there's
> no way to insure that #2 will work.
[quoted text clipped - 6 lines]
>
> Dave Peterson- Hide quoted text -

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.