Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Security within menus????
Hello - someone graciously answered my last post the creation of
menus, but now I have another:) Here's the scenario - my workbook has nine worksheets, each with financial data for nine specific company divisions. There is one division lead responsible for each division. The custom menu structure I created allows each lead to view and/or print there financial data. However, I cannot allow the leads to see each other's data. Is there a way to have the workbook open with all the worksheets hidden, and the accessible sub-menus accessible via password? So for example, the spreadsheet open requesting a password. The password entered by the user would detrermine what menus selections are available to them. Is this possible? Im open to better ideas as well :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sub-menus of main menus for Excel 2007 | New Users to Excel | |||
Creating Drop-down menus with subset drop-down menus | Excel Worksheet Functions | |||
difference between word 2003 menus and word 2007 menus-Explain pl | Excel Discussion (Misc queries) | |||
New Menus - attaching but menus are reset | Excel Worksheet Functions | |||
Overriding Actions of Excel DropDown Menus and Poup Menus | Excel Programming |