PassWord Protected Worksheet for End User
Posted by Jim Spencer on January 02, 2001 7:15 AM
I know this is simple for you Excel Experts, but I need it explained in plain English
Excel Worksheet has different tabs for Different departments..
Sheet1=DeptA, Sheet2= Dept B Tab Sheet3 = Dept C Tab etc..
I need a Visual Basic routine or Macro that when the Dept A manager clicks on the Sheet1, It prompts him to enter a Password before he/she can view the data. The Data is protected by the password before the End-user can view any of the data on Sheet1 Tab, etc.
Because of the sensitivity of Data only Dept A Manager can see Dept A data. If Dept A Manager clicks on Sheet2 for Dept B data, he/she would have to know Dept B manager's Password to access.
The clincher is the Director of Dept A B and C (sheet1,2,3,)should be allowed access to all three tabs. Therefore a highlevel password would allow the Director to enter his password to be able to access all 3 tabs for viewing/changing as needed.
Can you help...