Hi All,

have had a good look through but can not find any thread regarding this issue.

Been making a holiday request form for my work and have inserted a date and time picker onto the form (excel 2007)

everything was working fine and protected everything on the spreadsheet but after coming back in from the weekend the date and time picker just has a white box with a red x across it.

normally this only happens if I don't enable the macros which even after I do and unprotected the spreadsheet it still stay's the same.

I don't want to simply just re add the date and time picker for another few days to go by and the same issue to occur as the form is going to be used in theory for a lot more than a couple of days.

any help will be greatly appreciated :-)

Thanks JJ