kwalker24
New Member
- Joined
- May 19, 2010
- Messages
- 4
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
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