none
hide Excel 2007 Opening progress dialog

    Question

  • Anyone know how to prevent Excel 2007 from displaying the Opening progress dialog (with the cancel button on it) when opening a big spreadsheet from VBA?  I thought that turing Display alerts off would do it, but no luck. I tried making Excel invisible during the open as well but no improvement.
    ex.
    Application.DisplayAlerts = False
    Set wb = wbs.Open(Filename:="test.xls") 'opening dialog displayed w/ cancel button
    Wednesday, May 19, 2010 10:17 PM