Microsoft Date And Time Picker Control Excel 2016 Mac

P: 22
I have an excel file that I have been working on bit by bit over a few years, that I use as a basic, personal task tracker. I've built in task/milestone differentiation and a Gantt chart that moves relative to the selected date. I created a few basic controls to set the Gantt chart view (back one week, back one day, today, forward one day, forward one week), and I set up a date picker to set the view to any date of the user's choosing.
I recently moved to Office 2010, and now I'm having a problem with the Date Picker. It keeps re-positioning itself to the top-left corner of the sheet when I open the file. I then have to enter 'Design Mode,' manually re-position it, then exit design mode, and everything works as it should. Specifically, the date picker is designed to hover roughly over H4:J5, but on load it positions itself over the row/column headings at the top-left, varying in size some times (some times it covers A1:C2, others it's A1:H7). The fix is the same every time.
I've tried re-sizing, re-positioning, re-building and changing properties of the date picker, but nothing seems to make it load in the right position or size.
Further complicating things, I have VBA code that lets me hide the first three rows (a 'header' of sorts) for when I want to get down to business, so the date picker needs to be able to move with rows 4-5 so that it stays relative to the date control buttons (fwd, today, back).
The file is normally in .xlsm, but bytes.com won't let me upload that, so I've converted it to .xls. I have confirmed that all of the VBA functionality and the error persist in the .xls version of this file (I mostly just want the extra layers of conditional formatting).
Is there VBA code that I could use to force it to a specific location, yet still have it move with the 'hide header' control?
Thanks in advance for any consideration you can give to this problem.
Attached Files
SAMPLE TASK TRACKER.xls (1.73 MB, 574 views)
  1. Microsoft Date And Time Picker Control Excel 2016 Mac Os
PickerControl

Microsoft Date And Time Picker Control Excel 2016 Mac Os

The time is initially set to 9:00:00 AM (this is the default value of the txtSelectedTime textbox; it can be reset to another time as you wish). Click the Up arrow on the SpinButton control to increase the time, or the Down arrow to decrease the time; the complete date and time is displayed in the Selected Date and Time textbox. Hello Freestone: You should not have to use VBA for this issue. Go the the Developer tab in Excel 2010, then: (1) Click the Design Mode button in the Ribbon (2) Select the Date Picker you want to correlate to the cells (3) Right click the Date Picker and choose 'Properties' (4) Make sure the Checkbox property is True (5) In the Linked Cell property, enter the Cell address you want the value to.