OLE Controls moving, changing size

Question

I'm using the MSComCtl2 object, DTPicker1 in a spreadsheet as a convenient calendar control.  In the picture below, I've tried to bypass the problem by using MnthView1 instead of DTPicker1, which failed.  The different controls exhibit the same behavior.

The control itself works fine, but usually, when opening the sheet, the control to move to the top left of the open worksheet.  Not just to 0,0 of the sheet, but overlapping the row and column indicators.

Here's a screenshot of what it looks like:

I've tried setting .Top and .Left at Worksheet_Open.

Any ideas?  This is driving me nuts. :(

This is in Office/Excel 2010, by the way.

Answer 1

Can you provide simple steps to reproduce this behavior in Excel 2010 OR provide us the Excel file?

---

Click the 'Vote as Helpful' arrow if this post was helpful.

Answer 2

1. Open a new workbook in Excel 2010

2. Embed the Microsoft Date and Time Picker Control 6.0 (SP4) in Sheet 1.

3. Exit Design Mode.

4. Watch as the control seemingly duplicates itself and moves to the upper left bound of the worksheet, overlapping the column and row indicators.

A note about the 'duplication'... The 'original' is not interactive, but the 'duplicate' is. It's also worth noting that entering Design Mode again removes the 'duplicate' and makes the 'original' interactive again. Exiting Design Mode subsequently makes the 'duplicate' reappear.  Also, activating the Shape Selection Pane from the Page Layout tab will also make the 'duplicate' disappear and normal functionality resume until the workbook is reopened.

Answer 3

Hi ejballas.

I have reproduced the issue on my computer and reported the issue internally. Also, I recommend you to post this issue in Microsoft Connect:

http://connect.microsoft.com/

Sorry for any inconvenience and have a nice day.

---

Yoyo Jiang[MSFT]
MSDN Community Support | Feedback to us