Solved: Date picker userform - the size is changed

Hi

I am using a date picker userform, after I set it up to my desired size and save it, exiting excel and re starting it, the displayed userform size is changed.

Is there a way to LOCK the size / location of a userform ?

thanks !!!

If you are setting your size via the properties, then they should be saved. How are you actually setting it?

I just drag the edges to the size I wish.

save

exit excel


what do I do wrong ?


thanks

Are you dragging the edges in design view or in display view?

If you plan on using the calendar on more than one computer you should read this thread:

http://www.vbaexpress.com/forum/showthread.php?t=10914

Hey Lucas, do you know what "unreliabilities" in the Calander Control Ken was referring to?

Hi Aaron, principally, the library is not present on all machines, even with similar installations........see this from post #11 of the linked thread.

Quote:

---

it was working fine on the laptop i made the workbook on, but when i opened it up on another, almost identical machine it would throw a "can't find object or library" error.

---

If you want to use the native calendar control on a file that will be used on many machines you will run into this problem quite often. The only thing you can do is make sure the calendar control is installed on every machine it gets used on........an overwhelming caveat in most cases...

Excellent, thanks lucus.

I am pretty new to VBA.

Did not notice the Design mode.

Does it make any difference ?

thanks !

It's the difference between it getting saved or not:)

cool.

thanks a lot.