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.

It would probably be easier to just give each user his/her own workbook with
just the one sheet.

If you want to use the multi-sheet password method see this thread.

http://tinyurl.com/ysj6dw


Gord Dibben MS Excel MVP


On Wed, 5 Nov 2008 06:40:17 -0800, levine52
wrote:

I have a workbook that contains multiple worksheets. I want a particular
people to be able to view and edit one specific worksheet, and not be able to
see any of the other worksheets. Is there a way to set up a password for
specific worksheets? For example, I'd call one worksheet William, and
another Thomas. I'd then give Bill the password to the worksheet called
William, but he would not be able to see the workheet called Thomas.