+ Reply to Thread
Results 1 to 3 of 3

Excel 2010 - "Activex disappearing" bug

  1. #1
    Valued Forum Contributor
    Join Date
    08-31-2007
    Location
    SW Ireland
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20068) 32-bit
    Posts
    523

    Excel 2010 - "Activex disappearing" bug

    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
    Excel 365 user. To unblock a downloaded macro-enabled workbook, go to your "Downloads" folder > right click on the workbook name > click 'Properties' > check the 'Unblock' checkbox. You can now open the workbook.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel 2010 - "Activex disappearing" bug

    I am pretty sure MS are aware, but I don't know if it has been officially filed as a bug.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    11-08-2010
    Location
    Adelaide
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Excel 2010 - "Activex disappearing" bug

    I am having the same problem when saving a workbook with controls on hidden rows. I would have thought I could find more reports on the web than I have so am thinking everyone else knows about a new Excel 2010 setting that I am not aware of that is resulting in this problem. Any ideas?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1