Hi All,
I have created a workbook having 20 worksheets, Assume that the sheet names starts by "A" to "T". In brief, I want to authorize users to certain worksheets for example:
- User Name "AAA" with Password "XXX" To gain access from Sheet "A" To "J"
- User Name "BBB" with Password "YYY" To gain access from Sheet "K" To "R"
- User Name "ADMIN" with Password "ZZZ" To gain access To all Worksheets.
Is it doable, Can anyone help me to make it happen.
Appreciate your help.
Excello
I have created a workbook having 20 worksheets, Assume that the sheet names starts by "A" to "T". In brief, I want to authorize users to certain worksheets for example:
- User Name "AAA" with Password "XXX" To gain access from Sheet "A" To "J"
- User Name "BBB" with Password "YYY" To gain access from Sheet "K" To "R"
- User Name "ADMIN" with Password "ZZZ" To gain access To all Worksheets.
Is it doable, Can anyone help me to make it happen.
Appreciate your help.
Excello