COMPLEX worksheet protection help?

[Guest]

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]

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.

 

[Guest]

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]

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

 

[Guest]

thanks a ton. i'll check it out.

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