Date and Time Picker resizing itself

I set up a Date and Time picker object and have it working fine. The problem
is that when I close the excel workbook and then reopen it, the Date and Time
picker has resized itself. It is then too narrow and too tall.
To fix it, I go back to design mode and it returns to the correct height,
then I can move any of the handles to resize just a smidge and it is fine
again until I close the document, and yes I am saving before I close the
document.

Any suggestions?

object??
is it a control?
properties > don't resize with cells?

"Steve" wrote:

> I set up a Date and Time picker object and have it working fine. The problem
> is that when I close the excel workbook and then reopen it, the Date and Time
> picker has resized itself. It is then too narrow and too tall.
> To fix it, I go back to design mode and it returns to the correct height,
> then I can move any of the handles to resize just a smidge and it is fine
> again until I close the document, and yes I am saving before I close the
> document.
>
> Any suggestions?

Same issue here...

When i close and then reopen the sheet, my time and date picker control box changes size and no longer matches the cell its covering.

Zooming in and out makes it go back to normal but to someone using the sheet and dosent know that it just looks like a formating mistake.

I am having the same issue also - have changed the properties to each of the options for resizing with cells, and the same thing happens each time, have also removed any background colour, clicking on the box in design mode and moving it slightly fixes the problem, but as soon as it is saved and reopened the resizing occurs again, the box works fine either way - it just looks bad, I am trying to impress the boss at a new job and this is not very impressive!

I emailed to a friend and they didn't see any problems, so could it be a hardware or setup problem?

Would appreciate any tips or suggestions