Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I protect all excel tabs in a file with one password entry? | Excel Discussion (Misc queries) | |||
Password Protect independent excel tabs | Excel Discussion (Misc queries) | |||
Protect Individual Tabs Uniquely | Excel Worksheet Functions | |||
password protect individual worksheets | Excel Discussion (Misc queries) | |||
How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions |