LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 65
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
entering info into different worksheets exiled New Users to Excel 4 June 23rd 06 07:55 AM
How do I protect the cell from users entering values in Excel? Prasad NS Excel Worksheet Functions 1 January 12th 06 11:17 AM
getting info into a new tab and changes when entering in other tab Aimee Excel Worksheet Functions 0 September 23rd 05 04:37 AM
Can I lock info in Excel 2003 and users in Excel 2000 enter info? Mimmsan Excel Discussion (Misc queries) 1 September 8th 05 12:12 AM
How to keep users from entering a password on a shared workbook? alady31 Excel Discussion (Misc queries) 1 March 24th 05 05:19 PM


All times are GMT +1. The time now is 11:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"