protecting cells in excel from user but user can allow edit some cells but not all.

Question

i have written a vba code in excel which is accepting data from the user and do some calculations then ofter it will show the result in a same sheet,but i want to restrict the user to edit the cells he can edit cells which are not dealing with vba but he cannot edit the cells those are used by the vba.

Answer 1

Go in the Format Cell... (context menu) of the cells you want to be modifiable. In the Protection tab uncheck the Locked check box. Then you can protect the whole document and those cells should be still editable.