+ Reply to Thread
Results 1 to 5 of 5

An error message on open - a totally blank VBA message box

  1. #1
    Registered User
    Join Date
    07-08-2009
    Location
    Zurich, Switzerland
    MS-Off Ver
    Excel 2002
    Posts
    4

    An error message on open - a totally blank VBA message box

    Hello,
    I am struggling with the following problem (using MS Excel2007):

    I have an excel template with a userdefined ribbon built in.
    On open the excel file is loading data (from a text file) into it with VBA.
    Suddenly, during loading data into the worksheet i get an error message.

    => The message box that appears has no words, number or any other information on it. It is a totally blank VBA message box with the 'vbCritical' icon on it (red circle with the white X in it) with 'OK' and 'Help' buttons.

    I click on the 'OK' button and the loading continues, everything is loading correctly.
    [ I load the data from a big txt-file (372MB).]

    What it makes me thinking, if the txt-file is much smaller no error message appears.
    If i use the 'old'-excel templae without the ribbon, i do not get this error message.

    I just found a note in a tm1-forum:
    "I have seen cases where the Excel 2007 ribbon is "demolished" when running a (basic) Excel VBA macro."
    Source: http://www.tm1forum.com/viewtopic.php?f=3&t=2596

    How can this issue be solved ?
    How can this error message be avoided?

    Thanks for any comments!

    Regards,
    Roman

  2. #2
    Registered User
    Join Date
    07-08-2009
    Location
    Zurich, Switzerland
    MS-Off Ver
    Excel 2002
    Posts
    4

    Re: An error message on open - a totally blank VBA message box

    Issue solved.


    In Excel2007:

    The feature getVisible="GetVisible" and getEnabled="GetEnabled" is not working properly, delete everything of it in XML and VBA.

    Also, delete the onLoad="RibbonOnLoad" in the customUI.XML



    Test in Excel2010:

    No issue, no problems, there, it seems to work more stable.

  3. #3
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: An error message on open - a totally blank VBA message box

    Thanks for taking the time to post the solution .
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  4. #4
    Registered User
    Join Date
    09-30-2011
    Location
    Ljubljana, Slovenia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: An error message on open - a totally blank VBA message box

    I've had a similar issue. When some vba code was making calls to database and if user would click on the ribbon during it, blank message boxes would appear.

    The problem was traced to calls ribbon.Invalidate which occurred just before showing modal message boxes.

    I've solved this by putting calls ribbon.Invalidate after calls for showing modal message boxes. As Mr_Tigas pointed out this only occurs on MS Excel2007.

  5. #5
    Registered User
    Join Date
    06-06-2012
    Location
    Workd
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: An error message on open - a totally blank VBA message box

    [QUOTE=Mr_Tigas;2493779]Issue solved.


    In Excel2007:

    The feature getVisible="GetVisible" and getEnabled="GetEnabled" is not working properly, delete everything of it in XML and VBA.

    Also, delete the onLoad="RibbonOnLoad" in the customUI.XML



    Test in Excel2010:

    No issue, no problems, there, it seems to work more stable.[/QUOTE

    And how should the ribbon be loaded if you delete the onload from the XML? Also the advice to delete everything regarding getVisible and getEnabled isn't convincing. How should that work then if one wants to control the ribbon?

+ 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