Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMPLEX worksheet protection help?
This probably can't be done but here is my task:
I have a workbook set up for sales leads. There is a seperate worksheet for each salesperson where the boss enters leads distributed for them. He wants each of them to be able to update their sheet ONLY. Problem is when a salesperson opens the workbook, he doesn't want any of them to be able to SEE anyone ELSE'S worksheet (their own worksheet can be seen only). Those of us in administration would however be able to see ALL the worksheets immediately upon opening the workbook. I'm stumped. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMPLEX worksheet protection help?
Excel's protection isn't strong enough to do what you want.
If you have stuff that others shouldn't see, don't put it in excel--or don't share the workbook with others. I think I'd create multiple workbooks and then share them. Then consolidate those multiple workbooks into a single workbook. Matt wrote: This probably can't be done but here is my task: I have a workbook set up for sales leads. There is a seperate worksheet for each salesperson where the boss enters leads distributed for them. He wants each of them to be able to update their sheet ONLY. Problem is when a salesperson opens the workbook, he doesn't want any of them to be able to SEE anyone ELSE'S worksheet (their own worksheet can be seen only). Those of us in administration would however be able to see ALL the worksheets immediately upon opening the workbook. I'm stumped. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMPLEX worksheet protection help?
Thanks (and sorry for the double post).
Ok. Unfortunately the boss only knows excel so i'm stuck using it. If I set a seperate workbook up for each salesperson, and share them with my original, would the following be possible: Boss enters leads in current workbook on salesperson's sheet. Would that automatically update the salesperson's individual workbook? (would be in same folders on server) When salesperson updates his/her individual workbook, would that update the current workbook under their sheet? Hope that isn't too confusing (and thanks again for the help) "Dave Peterson" wrote: Excel's protection isn't strong enough to do what you want. If you have stuff that others shouldn't see, don't put it in excel--or don't share the workbook with others. I think I'd create multiple workbooks and then share them. Then consolidate those multiple workbooks into a single workbook. Matt wrote: This probably can't be done but here is my task: I have a workbook set up for sales leads. There is a seperate worksheet for each salesperson where the boss enters leads distributed for them. He wants each of them to be able to update their sheet ONLY. Problem is when a salesperson opens the workbook, he doesn't want any of them to be able to SEE anyone ELSE'S worksheet (their own worksheet can be seen only). Those of us in administration would however be able to see ALL the worksheets immediately upon opening the workbook. I'm stumped. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMPLEX worksheet protection help?
Oh, no.
Excel doesn't work that way. There aren't automatic updates. I'd use a macro to combine the sheets each time I got them back from the sales guys. Ron de Bruin has sample code at: http://www.rondebruin.nl/tips.htm Matt wrote: Thanks (and sorry for the double post). Ok. Unfortunately the boss only knows excel so i'm stuck using it. If I set a seperate workbook up for each salesperson, and share them with my original, would the following be possible: Boss enters leads in current workbook on salesperson's sheet. Would that automatically update the salesperson's individual workbook? (would be in same folders on server) When salesperson updates his/her individual workbook, would that update the current workbook under their sheet? Hope that isn't too confusing (and thanks again for the help) "Dave Peterson" wrote: Excel's protection isn't strong enough to do what you want. If you have stuff that others shouldn't see, don't put it in excel--or don't share the workbook with others. I think I'd create multiple workbooks and then share them. Then consolidate those multiple workbooks into a single workbook. Matt wrote: This probably can't be done but here is my task: I have a workbook set up for sales leads. There is a seperate worksheet for each salesperson where the boss enters leads distributed for them. He wants each of them to be able to update their sheet ONLY. Problem is when a salesperson opens the workbook, he doesn't want any of them to be able to SEE anyone ELSE'S worksheet (their own worksheet can be seen only). Those of us in administration would however be able to see ALL the worksheets immediately upon opening the workbook. I'm stumped. -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMPLEX worksheet protection help?
thanks a ton. i'll check it out.
"Dave Peterson" wrote: Oh, no. Excel doesn't work that way. There aren't automatic updates. I'd use a macro to combine the sheets each time I got them back from the sales guys. Ron de Bruin has sample code at: http://www.rondebruin.nl/tips.htm Matt wrote: Thanks (and sorry for the double post). Ok. Unfortunately the boss only knows excel so i'm stuck using it. If I set a seperate workbook up for each salesperson, and share them with my original, would the following be possible: Boss enters leads in current workbook on salesperson's sheet. Would that automatically update the salesperson's individual workbook? (would be in same folders on server) When salesperson updates his/her individual workbook, would that update the current workbook under their sheet? Hope that isn't too confusing (and thanks again for the help) "Dave Peterson" wrote: Excel's protection isn't strong enough to do what you want. If you have stuff that others shouldn't see, don't put it in excel--or don't share the workbook with others. I think I'd create multiple workbooks and then share them. Then consolidate those multiple workbooks into a single workbook. Matt wrote: This probably can't be done but here is my task: I have a workbook set up for sales leads. There is a seperate worksheet for each salesperson where the boss enters leads distributed for them. He wants each of them to be able to update their sheet ONLY. Problem is when a salesperson opens the workbook, he doesn't want any of them to be able to SEE anyone ELSE'S worksheet (their own worksheet can be seen only). Those of us in administration would however be able to see ALL the worksheets immediately upon opening the workbook. I'm stumped. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet tab protection | Excel Discussion (Misc queries) | |||
Worksheet tab protection | Excel Discussion (Misc queries) | |||
copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Seeking help for total worksheet protection | Excel Discussion (Misc queries) | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions |