DTPicker on Sheet Error

[gti_jobert]

Hi all,

I have placed a DTPicker on one of my sheets at it works fine - except
when i first open my application. The DTPicker displays a red cross and
then loads onto the sheet wrong - it look distorted and the wrong shape.


Anyone know any ideas to solve this? I have tried placing another
DTPicker on the sheet and it does the same thing. When I go onto
another sheet then reload my menu sheet the DTPicker is showing
perfectly.

TIA

 

[gti_jobert]

ok.....how do I use a calendar control on a spreadsheet without it
messing up?

TAIA

 

[DS-NTE]

Have the same problem, solved it by placing this in the ThisWorkbook module:

Private Sub Workbook_Open()
ActiveWindow.Zoom = 75
ActiveWindow.Zoom = 100
End Sub

 

[gti_jobert]

Thank you so much, solved the issue!!