Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Protecting cells dans Excel mais allow these vers be modified by VBA script

ayi

I am using Excel where certain fields are allowed for user input and other cells are to be protected. I have used Tools Protect sheet, however after doing this I am not able to change the values in the VBA script. I need to restrict the sheet to stop user input, at the same time allow the VBA code to change the cell values based on certain computations.
<hr>
Source : <a href="https://stackoverflow.com/a/14162717/11683" rel="noopener nofollow ugc">Stack Overflow</a>.)

ayi_2

Try using 
Worksheet.Protect “Password”, UserInterfaceOnly := True <pre><code class="lang-auto"> If theUserInterfaceOnly` parameter is set to true, VBA code can modify protected cells.

Note however that this parameter does not stick. It needs to be reapplied each time the file is opened.</code></pre>