Hi everybody - Im new in this forum and learning to use Excel. I am not a super user, so please bear over with me :D I do not understand how to use VBA, yet.

I have an issue I guess you can answer. I have made this sheet, where I demand the user to put in a date. The function/Control element I use is "Microsoft Date and Time Picker Control 6.0". It suits my sheet well.

I do have one issue. When I save the Excel sheet as a template with macros, and I open the template, the date and time picker looks like it did not start correctly or is in design mode (Which it is not).

I can make the date and time picker work when I scroll up and down 1 step with my mouse wheel.

As the sheet is going to be used by persons who are unfamiliarized with these kind of small problems, I strive to get this date and time to work to avoid complaints.

Do you have a suggestion on how to solve this?

Can I make some kind of code that "Refresh" upon startup, so I simulate the up and down motion from my mouse wheel?


Thank you in advance - I hope you can help me.


Best regards

Mr.knond