One trick I have employed to prevent the user being able to edit the cell directly:
- insert an active-x Label
- position it over the cell
- make it the same size as the cell
- make it transparent
- make it move and resize with the cell

Then to amend the cell value
- attach a click event macro to the Label which triggers your date picker