In my company I have to divide up our expense reports by Cost Center. It would be easier to just send everything out in individual workbooks but the higher executives do not want to sort through 10 different ones. Is there a way I can create a login and password that directs you to what you are allowed to look at. We have 10 different cost centers and I need to create one for each of those groups that only allows them to view only their page. Then there is the executives and presidents that need to be able to view the entire workbook. I created one where people could put a password in at each page but it displayed the information on the page in the background. Is there something else that I could use with a step by step process on how to create the two different levels of access.


Private Sub Worksheet_Activate()
a = InputBox("Please Enter Password")
If a <> "Password" Then
MsgBox "Wrong Password"
Sheets("Sheet1").Visible = False
End If
This is what I used previously but like I said this information displayed when you clicked on each page is not going to work. Also the executives do not want to type in a password at each page.


Thank you in advance for your help