It is possible but involves a whole lot of VBA code to hide sheets and
arrange passwords or login names for each user.

Also a contingency plan if users decide to disable macros when opening the
workbook.

You also have the weakness of Excel's internal security to deal with and
hiding the code from prying eyes.

I would suggest your time and effort be directed to using the Master
workbook to update each user's data on user's worksheet.

Each user has his/her own workbook with one sheet that is linked to his/her
sheet in the Master workbook.


Gord Dibben MS Excel MVP

On Tue, 1 Dec 2009 10:24:01 -0800, KA wrote:

I have an excel workbook with 60 tabs (worksheets) that contain user
production data and I need a way that when someone opens up the workbook they
only see the (worksheet) tab with their information only and not the entire
workbook. Is there a way to do this in excel?

Thank you!