Register
Log In
Unanswered
Home
June 25, 2016
Offline
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,
See Answer
Dashboards
June 25, 2016
Offline
Hi rathanak
Try this.
Sunny
Answers Post
Most Users Ever Online: 57
Currently Online: azri adrin, Mark Lund, Rudi
19 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ajay Mukhi
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Janel Oz
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
