I'm using Excel 2007. I'm saving the file in Compatibility Mode because everyone else has Excel 2003.
I created a Chart Sheet (not a chart on a worksheet) to chart data and put some Form Control combo boxes on it to select the range of data to chart. There are also some Form Control labels.
When I close the sheet and then open it again, the controls have moved as dispayed in the images below. The combo boxes get very large and move down the sheet. How can I get them to stay where I put them or move back to where I put them programatically?