I think I would just make ALL the tabs hidden, except the first screen which
would be a sign-in sheet asking for a persons name and password which would
then allow a macro to open their sheet only..........as for actually
"preventing" a hacker from viewing/editing any other sheet, that part is
pretty well impossible in Excel......we can only make it so difficult the
hacker "might" give up trying.

Vaya con Dios,
Chuck, CABGx3


"Gary" wrote in message
...
Hi
one of my friends asked this question and i did not have an answer so
posting it here.

I want the work book to be shared by mulitiple users. Each user should
have
a tab dedicated to them. Apart from the administrator nobody should be
able
to view/edit others' tab.

Well, for the last point: I am planning to create an application (might be
in VBA) to fetch data from all the tabs and to report the same in other
excel work book.

Thanks
Gary