sheets lock for edit or protect sheet but macro can add data

Dear member i create small macro to book test drive . there are 3 sheet , i want to lock all cells on 2nd sheet where is my dashboard except buttons and only D3 cell where i have to click and select date. and 3rd sheet where my all data store. please help to lock this two sheet

Dear djbomaha
thanks for prompt reply... i tried code but it getting error variable not define. please tell me what is variable type. and one more thing is this code stored data from user form and display on dashboard ?

Hi,

I edited the code above to define "i". It is the only variable in the code. The code posted is stand-alone and could be run independently. It could be called from a button on your workbook or from a form control on a userform as well depending on what you are trying to do.

Thanks,

Dan

Dear djbomaha,
Thanks for your support...
please find attached same macro i want to do some changes in it but i dont know how to start . please help me


i want to do some changes in sheet2 which is "check availability" i want to add to more color in it that is cyan for washing and yellow for Other facility TD (i was used it for double booking ) . i will add one more control on form whre i give facility to choose the purpose of booking vehicle like for test drive , washing ,other facility TD etc. according to that my dashboard shows color.
all code is in test module .....
please help