values still change while lockeds

[king0242]

hi
how do i lock a sheet but still allow values to be changed or entering new values
because my cells contain formula and some of them triggered by some vba code.

e.g when i try to lock my sheet and enter a value in a userform that will change the values in other cells. then "run-time error '1004'" appear

what i want is to prevent other user to change the format, formula and edit the fixed values.

 

[Jon von der Heyden]

Hi

In your code you need to unprotect the sheet, apply the formulae / value changes and then re-apply worksheet protection.

Example:

Sheets("Sheet1").Unprotect "PASSWORD"
    'Some code here
Sheets("Sheet1").Protect "PASSWORD"