DTPicker Resizing

  • Thread starter Thread starter Lonnie
  • Start date Start date
L

Lonnie

I am using Excel 2003 (SP2) and dropped a 'Microsoft Date and Time Picker
Control 6.0 (SP6)' onto the worksheet. When I close and reopen the workbook
the DTPicker resizes to about five times the original height. It does not
change in width. I have seen other forums with people having the same issue,
but have not seen any options that work. This has also been tested on a
machine with Excel 2003 (SP3).

Thank you,

Lonnie
 
I have had that before and I didn't find the answer.
The workaround we found was to change to another sheet before saving the file.
When you reopen, you see the other sheet. And when you change back to the
sheet with the DTpicker it is the right size.
 
I had this issue, but the cure was to unfreeze then refreeze panes on the
workbook open event.
Private Sub Workbook_Open()
Sheets("Missed Orders").Activate
Range("C4").Select
ActiveWindow.FreezePanes = False
ActiveWindow.FreezePanes = True
Range("C4").Select
 
Back
Top