BigCountry37
New Member
- Joined
- Oct 22, 2009
- Messages
- 15
Trying to write a code that will accomplish the following:
1. If cell "H16" is "Yes" then unlock range E47:E53
2. If cell "H16" is "No" then fill range E47:E53 with zero's and lock.
Given-working on Sheet5, and let me know if the range E47:E53 needs to be normally locked or unlocked. Also sheet will be protected with a password.
Please help!!
1. If cell "H16" is "Yes" then unlock range E47:E53
2. If cell "H16" is "No" then fill range E47:E53 with zero's and lock.
Given-working on Sheet5, and let me know if the range E47:E53 needs to be normally locked or unlocked. Also sheet will be protected with a password.
Please help!!
