Home |
Search |
Today's Posts |
#1
|
|||
|
|||
multiple pages for multiple users
Before creating the workbook.
I want to set up a workbook with multiple worksheets. I want each of the worksheets to have its own password to allow the assigned user to only access to that sheet. I still want in place a passcode for me to protect what I want to protect. Does this make any sence? Can it be done like in the scenario? Or is it too complex? It is going to be one workbook -- 19 worksheets (two hidden, one view only and 16 individual users? Any other suggestions will be appreciated? fourskunks |
#2
|
|||
|
|||
Excel isn't made for this kind of security. If the data is not supposed to be
seen by the other users, don't share it in excel. Worksheet and workbook protection (via tools|protection) is very easily broken. fourskunks wrote: Before creating the workbook. I want to set up a workbook with multiple worksheets. I want each of the worksheets to have its own password to allow the assigned user to only access to that sheet. I still want in place a passcode for me to protect what I want to protect. Does this make any sence? Can it be done like in the scenario? Or is it too complex? It is going to be one workbook -- 19 worksheets (two hidden, one view only and 16 individual users? Any other suggestions will be appreciated? fourskunks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sharing a workbook and incorporating changes from multiple users | Excel Worksheet Functions | |||
How to allow multiple users to update workbook (on network)? | Excel Discussion (Misc queries) | |||
Excel workbook to be used by multiple users at same time....possible??? | Excel Worksheet Functions | |||
Single worksheet, multiple pages? | Excel Discussion (Misc queries) | |||
combining multiple pages from Web automatically | Excel Discussion (Misc queries) |