This is not so much a question as an observation on what appears to be an extraordinarily bad bug in Excel 2010.
Open a new, blank workbook and do the following:
1. Use the developer tab to Insert an ActiveX control [a checkbox is what I used] on a worksheet
If the 'Developer tab' is not displayed on the ribbon, click File | Options | Customize ribbon and on the right panel click Developer tab
2. Right click the control, Format control...| Properties tab | Move and size with cells
3. Hide the row (maybe 2 rows) on which the control is placed.
4. Save the file and close it (the rows are still hidden)
5. Reopen the file and unhide the relevant rows- your control has disappeared??????
What's even more odd is that if you now click the 'Find and Select' button on the right of the Home tab and choose 'Selection pane', the control will be shown as being on the worksheet but it isn't possible to make it visible. I've done a limited internet search and found this behaviour being experienced by others.
My question: does anyone know of a fix or whether Microsoft is aware and working on this problem (and how to report it to Microsoft as a problem)?
Thanks,
Brian
Bookmarks