Password protect individual tabs in an excel spreadsheet

  • Thread starter Thread starter Mick
  • Start date Start date
M

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Password Protection 6
How do I email individual tabs in a workbook? 1
Excel Opening Problems ? And, Other Equiv Spreadsheets ? 1
Grayed out Tab in Excel 1
How do I email a single spreadsheet tab in excel? 2
Folder/Tabs Newbie Question 2
restrict access to individual users - excel tabs 5
Password Protect independent excel tabs 1

Back
Top