'SetFocus' / 'Activate' function not working for control elements (activeX) on frozen part of worksheet RRS feed

  • Question

  • Hi Everyone,

    I have few text boxes and dropdown lists on a worksheet (Excel 2007) and I want to navigate between them using 'tab' or arrow keys. I have used "Activate" function (as these elements apparently don't support 'SetFocus').

    I have freezed a part of my worksheet, the elements become invisible when i press either arrow or tab keys. When i move these particular elements to the unfrozen area, they work fine and as expected. I have no clue, why this is happening. Any kind of suggestions are welcome.

    Thanks and Regards,


    • Moved by Youen Zen Wednesday, December 12, 2012 7:28 AM Appropriate forum for this issue (From:Visual Basic General)
    Tuesday, December 11, 2012 9:42 AM

All replies