Environment versions
Microsoft Office:
Office XP 2002
I have following type of data in excel file and the file is encrypted for open with passward "123" when we opens the file and gives passward 123 it shows all records which is OK.
branch Emp Code
lucknow 123
lucknow 456
lucknow 789
kolkatta 12
kolkatta 14
kolkatta 18
kolkatta 20
Shimla 55
Shimla 58
Shimla 56
Shimla 102
Is there any method TO FIX THREE SEPRATE PASSWARDS FOR THREE SECTIONS for example
if user puts "123" as passward only following be display
lucknow 123
lucknow 456
lucknow 789
if user puts "999" as passward only following be display
kolkatta 12
kolkatta 14
kolkatta 18
kolkatta 20
if user puts "888" as passward only following be display
Shimla 55
Shimla 58
Shimla 56
Shimla 102
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only