Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet access dependent on security
For one approach, see this from Jimmy L. Day:
http://myweb.cableone.net/twodays/se...userunhide.xls He doesn't provide any explanation, but enter any of these names: Jimmy Margaret Esther George LLoyd When prompted and see the result. Then press Alt+F11 to see the VBA code. For you own use, you could hide the VBA code by using a password. Have a nice day. -- Eric van Uden at the foot of the 'bridge too far' "tag" schreef in bericht ... Is it possible to allow some users access to all worksheets in a workbook while others only have access to some worksheets in the same workbook? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet access dependent on security
I understand how that works for 1 worksheet per person and
it is great...but I need to take it one step further. What about a situation where I have 5 worksheets that everyone can see (all named differently) and an additional 5 worksheets that only executives can see. Basically executives could see all 10 worksheets where anyone other than an executive could see only 5 of those worksheets. Thoughts? Thanks. -----Original Message----- For one approach, see this from Jimmy L. Day: http://myweb.cableone.net/twodays/se...userunhide.xls He doesn't provide any explanation, but enter any of these names: Jimmy Margaret Esther George LLoyd When prompted and see the result. Then press Alt+F11 to see the VBA code. For you own use, you could hide the VBA code by using a password. Have a nice day. -- Eric van Uden at the foot of the 'bridge too far' "tag" schreef in bericht ... Is it possible to allow some users access to all worksheets in a workbook while others only have access to some worksheets in the same workbook? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - security / limiting access | Excel Discussion (Misc queries) | |||
List Dependent Worksheet Functions | Excel Discussion (Misc queries) | |||
Q about trace dependent to worksheet icon | Excel Discussion (Misc queries) | |||
Security for Viewing MS Access Databases From Excel Datasource | Excel Discussion (Misc queries) | |||
Database Access, Security and Audit Trails in Excel | Excel Programming |