DTPicker on Sheet Error
 

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
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=534052

DTPicker on Sheet Error
 

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

TAIA


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=534052

DTPicker on Sheet Error
 

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" skrev
i melding ...

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
------------------------------------------------------------------------
gti_jobert's Profile:
http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=534052

DTPicker on Sheet Error
 

Thank you so much, solved the issue!!


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=534052