Err, obviously you would not manually protect the sheet if you are
doing so via code. Please ignore step 3.

On Feb 19, 3:21*pm, JP wrote:
You didn't say what Excel version you are using. In Excel 2003, you
would lock the cells you want to protect, and unlock the ones you want
the user to edit. Then you would protect the worksheet in the
Workbook_Open event, with additional code to allow only macros to make
changes to the locked cells.

1. Select cells you don't want to be changed (i.e. B1), press Ctrl-1,
go to Protection tab, check "Locked" and "Hidden"
2. Select cells you want to allow editing, press Ctrl-1, go to
Protection tab, UNcheck "Locked" and "Hidden"
3. Go to ToolsProtectionProtect SheetOK.