Hi All,

i have a very peculiar problem

i my work sheet i have a date time picker control. it works fine every
thing is working fine but...............

each time i open my work book this date time picker control will be
resized

(assume if the original height = 17.25 and width = 139.5 it is be
changed to height = 20 and width = 50)

if i move horizontal or vertical scroll bars the sizes get reseted to
original size.
this is making my work sheet look very ugly at the time of opening the
file.


Plz Plz Plz help me out to solve this probelm.
1. How to make my date time picker size unchanged during opening of the
file.


--
sjayar
------------------------------------------------------------------------
sjayar's Profile: http://www.excelforum.com/member.php...o&userid=28435
View this thread: http://www.excelforum.com/showthread...hreadid=484201

Not sure why it would resize, but why not set the width/height properties in
the workbook_open() event?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"sjayar" wrote in
message ...

Hi All,

i have a very peculiar problem

i my work sheet i have a date time picker control. it works fine every
thing is working fine but...............

each time i open my work book this date time picker control will be
resized

(assume if the original height = 17.25 and width = 139.5 it is be
changed to height = 20 and width = 50)

if i move horizontal or vertical scroll bars the sizes get reseted to
original size.
this is making my work sheet look very ugly at the time of opening the
file.


Plz Plz Plz help me out to solve this probelm.
1. How to make my date time picker size unchanged during opening of the
file.


--
sjayar
------------------------------------------------------------------------
sjayar's Profile:
http://www.excelforum.com/member.php...o&userid=28435
View this thread: http://www.excelforum.com/showthread...hreadid=484201

still the same problem.
don't know how to solve this


--
sjayar
------------------------------------------------------------------------
sjayar's Profile: http://www.excelforum.com/member.php...o&userid=28435
View this thread: http://www.excelforum.com/showthread...hreadid=484201

Can the workbook be emailed to me?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"sjayar" wrote in
message ...

still the same problem.
don't know how to solve this


--
sjayar
------------------------------------------------------------------------
sjayar's Profile:
http://www.excelforum.com/member.php...o&userid=28435
View this thread: http://www.excelforum.com/showthread...hreadid=484201