Mittwoch, 2. Mai 2012 20:43
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.
Donnerstag, 3. Mai 2012 04:43Can 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.
Donnerstag, 3. Mai 2012 16:22
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.
- Bearbeitet ejballas Donnerstag, 3. Mai 2012 16:25
Montag, 7. Mai 2012 08:39Moderator