GOUTAM PAUL
New Member
- Joined
- Jun 1, 2020
- Messages
- 2
- Office Version
- 2007
- Platform
- Windows
Respected Sir/Madam.
I am a basic user. I had made a searchable dropdown list by formula (List, Vlookup, Search & etc.) in the same worksheet. I want to lock the table, from which the dropdown list had created, as nobody can change the DATA on that table. If I protect the sheet by password, then the dropdown list does not work. If l allows to edit the cells of the TABLE then it works, but protection disabled of the TABLE. I also checked that if the table in the another sheet of the same workbook, then also it happens. Please help me to solve the problem.
I am a basic user. I had made a searchable dropdown list by formula (List, Vlookup, Search & etc.) in the same worksheet. I want to lock the table, from which the dropdown list had created, as nobody can change the DATA on that table. If I protect the sheet by password, then the dropdown list does not work. If l allows to edit the cells of the TABLE then it works, but protection disabled of the TABLE. I also checked that if the table in the another sheet of the same workbook, then also it happens. Please help me to solve the problem.