Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password Protect independent excel tabs
Can I independently p/w protect varied tabs of an excel 2003 workbook so that
varied users can only view tabs they are specifically granted access to (via p/w)? EG, tabs 1 - 9 are for data entry by 9 parties and tab 10 is a merged report based upon the date of tab 1 - 9. Each user needs read / write for their own tab, but NOT for others. Thoughts? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password Protect independent excel tabs
You can do this but remember that Excel's internal security is very weak and
passwords easily broken. Have a look ar this google search result for a few pointers with a couple of attack methods and some code. http://tinyurl.com/ysj6dw Jerry has the sheet_activate method and I use the workbook_open and close to hide sheets. Gord Dibben MS Excel MVP On Mon, 5 May 2008 10:00:01 -0700, Brian K <Brian wrote: Can I independently p/w protect varied tabs of an excel 2003 workbook so that varied users can only view tabs they are specifically granted access to (via p/w)? EG, tabs 1 - 9 are for data entry by 9 parties and tab 10 is a merged report based upon the date of tab 1 - 9. Each user needs read / write for their own tab, but NOT for others. Thoughts? |
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) | |||
How do I password protect a workbook in Excel? | Excel Discussion (Misc queries) | |||
password protect a file in Excel 2007 | Excel Discussion (Misc queries) | |||
password protect the button in Excel? | Excel Discussion (Misc queries) | |||
Password protect an Excel Document from viewing | Excel Discussion (Misc queries) |