just a start,
select the cells that need data, right click on mouse,select format
cells, select protection tab, then uncheck the hide box,
now when the sheet is protected, you will still be able to input data
in the selected cells,
you can also have unprotect sheet in your macro
Hope this gives you a start