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