Password protect individual tabs in an excel spreadsheet
 

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?

Password protect individual tabs in an excel spreadsheet
 

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?