Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel
Message
From
03/07/2014 07:16:02
 
 
To
All
General information
Forum:
Microsoft Office
Category:
Excel
Title:
Excel
Environment versions
Microsoft Office:
Office XP 2002
Miscellaneous
Thread ID:
01603176
Message ID:
01603176
Views:
55
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
Map
View

Click here to load this message in the networking platform