nithin shettigar
New Member
- Joined
- Mar 16, 2014
- Messages
- 44
Please help me out with VBA code, if I enter “ok” any ware betweenE1:E500 entire row should be protected.
Eg – If I enter ok in “E2” then “A2:D2” should be protected
<colgroup><col width="26" style="width: 20pt; mso-width-source: userset; mso-width-alt: 950;"><colgroup><col width="84" style="width: 63pt; mso-width-source: userset; mso-width-alt: 3072;"><colgroup><col width="64" style="width: 48pt;"><colgroup><col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" span="2"><colgroup><col width="64" style="width: 48pt;"><colgroup><col width="115" style="width: 86pt; mso-width-source: userset; mso-width-alt: 4205;"><tbody>
</tbody>
Eg – If I enter ok in “E2” then “A2:D2” should be protected
A | B | C | D | E | ||
1 | Name | Place | Date | Time | Remark | |
2 | Suhan | Dubai | 15/01/2019 | 11:57 PM | ok | protect row |
3 | Nithin | Dubai | unprotect row | |||
4 | Yash | Dubai | 15/01/2019 | 12:57 PM | ok | protect row |
<colgroup><col width="26" style="width: 20pt; mso-width-source: userset; mso-width-alt: 950;"><colgroup><col width="84" style="width: 63pt; mso-width-source: userset; mso-width-alt: 3072;"><colgroup><col width="64" style="width: 48pt;"><colgroup><col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" span="2"><colgroup><col width="64" style="width: 48pt;"><colgroup><col width="115" style="width: 86pt; mso-width-source: userset; mso-width-alt: 4205;"><tbody>
</tbody>