Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering info into different worksheets | New Users to Excel | |||
How do I protect the cell from users entering values in Excel? | Excel Worksheet Functions | |||
getting info into a new tab and changes when entering in other tab | Excel Worksheet Functions | |||
Can I lock info in Excel 2003 and users in Excel 2000 enter info? | Excel Discussion (Misc queries) | |||
How to keep users from entering a password on a shared workbook? | Excel Discussion (Misc queries) |