Password protect individual tabs in an excel spreadsheet

[Mick]

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?

 

[Gord Dibben]

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