Notifications
Clear all
Topic starter
Hi excel expert,how can we write code to lock some ranges if select drop down list Locked the ranges will be locked otherwise unlocked
For example as i choose from drop down list the words locked in cell C2 then ranges A3:E10 automatically locked,if not choose it unlocked
Regards,
Posted : 17/12/2016 2:46 am
Hi rathanak
Try this.
Sunny
Posted : 17/12/2016 3:39 am
Topic starter
Sunny,i run code in your excel file,it works but as i modify my code like you it locked it not allowed me to select from drop down list,why?
anyone here comment any solution?
regards,
Posted : 17/12/2016 4:28 am
Hi rathanak
Just unprotect the input cell C2 before you protect the worksheet.
Sunny
Posted : 17/12/2016 10:29 am
