problem in date time picker size

S

sjayar

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.
 
N

Nick Hodge

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
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Date Picker problem 0
Set date time picker to null (blank) 5
date and time picker control error 2
Microsoft Date and Time Picker 1
Changing a Data Time Picker Control 3
date and time picker control in excel vba 1
Date and Time Picker resizing itself 1
Tab Control and Date Time Picker Error 1

Top