sharing to see part of range

  • Thread starter Thread starter loparque
  • Start date Start date
L

loparque

Hi, I have a question.
I have a excel file shared with 10 persons throught the net, but eac
needs to see differents data in differents ranges and I don´t want the
see all the data.
Is it possible restrict the view for each users ?
thank you !!!
 
Excel's protection scheme isn't really made for security. (I think) it's really
meant to stop the user from overwriting locked cells. There are posts here
every day that show how to unprotect worksheets.
 
I haven't done it, but I could conceive of a system working whereby you have
a separate hidden sheet for each user, with one main open sheet as a sign-in
sheet, ............when the book opens the user would sign in with their PIN
number and that would trigger a macro which would open only "their" sheet,
and erase or delete all the others............

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top