Problem With Date Picker

C

CoolCyber

Hi,
I have used Microsoft DatePicker control in a spreadsheet. But everytime i
open the sheet, the date picker is disfigured. It elongates vertically and
reduces in size vertically. But if i scroll to make it not visible and
scroll back it displays correctly. I have tried giving its location, width
etc when workbook loads, but its of n ow use. Any Ideas on how to make it
display properly.

Prn
 
T

tra

If scrolling seems to work then it's probably a graphics problem. Maybe
Excel isn't redrawing the screen properly until you scroll up and down.

You could try writing a macro that automatically scrolls the sheet when
you open it then scrolls back
 
C

CoolCyber

Thanks for the reply. Well thats what im doing right now, scrolling up &
down using a macro. But am not sure if it would work for all. so was looking
for a better solution.

Prn
 
Top