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 |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 - |
Reply |
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) |