Why is the DatePicker control changing Sizes when I re-open File?

[ions]

Dear Excel Expert.

My datepicker control in my Excel App (=EMBED("MSComCtl2.DTPicker.2","") appears very large every time I open the file. I am using Excel 2003.

When I go to design view and adjust it, it stays the correct size but when I re-open the Excel file it's very large again.

Please see the attached screen shots for a clearer explanation of the problem.

Thank you for your response.

[JosephP]

activex control+worksheet=weird behavior :-)

especially if you use zoom settings other than 100%

[ions]

Thank you for the response JosephP. If I change the zoom it fixes the problem but still every time I open the workbook the activex control is large despite saving the workbook at 10% zoom.

Thanks again for your response much appreciated.

[JosephP]

did you mean 10% or 100%? activex controls are not very reliable on worksheets so you would require code to resize it when the workbook opens

[ions]

Sorry I meant 100%.

[valimaties]

I know it is a very old post, but I found a workaround for this problem.
Open VBA Project by hitting Alt + F11, find ThisWorkbook Excel object and insert the following code:

Please Login or Register  to view this content.

This code will activate each sheet and wil do a little scroll, down and up. In this way ActiveX objects will be refreshed and restore last saved size.

Regards,
Vali

[RachelMacroNewbie]

Thanks for replying. This helped a lot.