Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, thanks for answering, im allready using Application.DisplayAlerts = False
application.DisplayAlerts(false); this is the method im using on my side of a COM object this gets rid of the "do you wanna save" box. But what I want is to get rid of a messagebox that comes due to a VB run-time error created inside excel as its closed. This messagebox stops windows from closing the file and that meens that someone is still accessing the file and then I cant move the file to another loaction. as Application.DisplayAlerts = False only seems to remove normal allerts such as remember to save I was wondering if there would be something to ignore or auto close a runtime error message. hope I make any scense :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
why do all excel worksheets/workbooks close when I close one? | Excel Discussion (Misc queries) | |||
Not close thead when I close excel | Excel Programming | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel | |||
combo box close on selection help!! | Excel Programming |