+ Reply to Thread
Results 1 to 7 of 7

Userform in Excel 2013 disappears while switching an active workbook behind

  1. #1
    Registered User
    Join Date
    07-05-2012
    Location
    Kiev, Ukraine
    MS-Off Ver
    Excel 2010
    Posts
    12

    Userform in Excel 2013 disappears while switching an active workbook behind

    Hello, guys.

    I have faced one problem in Excel 2013. In my project, I have a userform that contains a listbox which lists names of all opened excel books. When a user clicks on a particular name in the list, the appropriate book is activated. So the userform is always on top and while the user is clicking on the names in the list, he can see all opened workbooks getting activated one by one behind the active userform. This is the way it used to work in Excel 2010.
    Now, after upgrade from 2010 to 2013, if a user clicks on a name in the list, selected workbook gets activated but the userform disappears.

    The 1st question is what exactly has been broken in Excel 2013 and what is the way to bypass this problem. Could you please advise me?
    The 2nd is WTF and has any monkey with its hands grown from its a$$ ever thought about inter-version compatibility?
    Thank you in advance!

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Userform in Excel 2013 disappears while switching an active workbook behind

    Excel 2013 is SDI interface and not MDI. I do not know answer to second question.

  3. #3
    Registered User
    Join Date
    07-05-2012
    Location
    Kiev, Ukraine
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Userform in Excel 2013 disappears while switching an active workbook behind

    Yes, I see now. Is there any way to walk around?

  4. #4
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Userform in Excel 2013 disappears while switching an active workbook behind

    I do not know. Is this form shown as modal or modeless?

  5. #5
    Registered User
    Join Date
    07-05-2012
    Location
    Kiev, Ukraine
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Userform in Excel 2013 disappears while switching an active workbook behind

    the form is modal.

  6. #6
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Userform in Excel 2013 disappears while switching an active workbook behind

    I think you must use Windows API like here: http://www.jkp-ads.com/Articles/keepuserformontop02.asp

  7. #7
    Registered User
    Join Date
    07-05-2012
    Location
    Kiev, Ukraine
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Userform in Excel 2013 disappears while switching an active workbook behind

    OK, thank you, I will look into it...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Fuzzy GIF images uploading to UserForm picture in Excel 2013
    By AdLoki in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2013, 04:12 AM
  2. Alt-tab to another workbook when userform is active
    By Timelessness in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-03-2013, 09:50 PM
  3. Maximize Userform on Workbook Active
    By savio21 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-07-2011, 11:01 AM
  4. Excel is switching date formats between userform and worksheet
    By madbloke in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-09-2008, 03:11 AM
  5. [SOLVED] USERFORM DISAPPEARS ON EXCEL MINIMIZE
    By Ian Digby in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2006, 04:55 AM

Tags for this Thread

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