Can be done using VBA and hidden sheets with passwords but Excel's internal
security is very weak and it would take a moderately competent user with
access to the Internet a very short time to crack the passwords and access
all sheets.

You would be much safer giving each user their own workbook.

Are you on a network with each user having a login ID/name?

See this thread for some examples of hiding/unhiding sheets without having
each of them individually passworded.

Visible sheet depends upon user login name or an entered password.

http://tinyurl.com/betmvp


Gord Dibben MS Excel MVP

On Mon, 2 Feb 2009 12:47:01 -0800, Mick
wrote:

Could you tell me if it's possible for me to password protect individual tabs
on a spreadsheet (I don't want people to open tabs for other people - only
their own). For example, I'll have 8 tabs on the bottom of a single
spreadsheet, with each person only able to open their individual tab.

Any suggestions?