View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JoeJoe JoeJoe is offline
external usenet poster
 
Posts: 8
Default 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 :)