<div>
<div class="content wysiwyg-content">
I need help with a code. &nbsp;<br />
<br />
basically,<br />
<br />
the code should not allow user to modify any values into the followings ranges of Sheet(&quot;Data&quot;)<br />
<br />
the only modification should be allowed by the Sub procedure that writes values into these cells that procedure name is Macro500<br />
<br />
i googled to find the worksheet change event that restricts but i could not find something useful.<br />
<br />
A33:B34<br />
A38:B39<br />
A15:B16<br />
A21:B28<br />
D15:K17<br />
C21:K30<br />
D32:K35<br />
C38:K40<br />
B6:C9
</div>
</div>


I need help with a code.  

basically,

the code should not allow user to modify any values into the followings ranges of Sheet("Data")

the only modification should be allowed by the Sub procedure that writes values into these cells that procedure name is Macro500

i googled to find the worksheet change event that restricts but i could not find something useful.

A33:B34
A38:B39
A15:B16
A21:B28
D15:K17
C21:K30
D32:K35
C38:K40
B6:C9

how can i restrict modification/change of certain ranges in a worksheet with VBA

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.