You could have an input box routine in the Auto_Open Macro. The user would
be asked to imput their name or password. The If - Then Clauses would then
be set to make the appropriate sheet visible. The Auto_Open routine would
first make only a Title sheet or blank sheet visible.
--
Pops Jackson


"sherobot" wrote:

How can I protect worksheets in a workbook where only certain users can view
certain worksheets.
So if Joe opens up the workbook he can only see the work sheet for Joe and
no others.
thanks