DTPicker on Sheet Error

G

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
 
G

gti_jobert

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

TAIA
 
D

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
 
Top