Capture ''Yes to all when closing Excel

When I close Excel and click "Yes to All" it does not close until I click the top X again. This is an Excel bug caused by using Workbook_Deactivate in multiple workbooks. Does anyone have VBA API code to trap this event and allow me to close all workbooks.

Please note I and others have made extensive efforts to solve this problem using the Workbook_BeforeClose and Workbook_Deactivate events. It is almost certainly not possible to do it using these events without introducing some other unwanted behaviour.

It may be possible using the Windows API, by doing something along the lines of getting the handle of the close dialog box window, then getting the "YEs to Alll" button ID.

Habilidades: Arquitetura de software, Área de trabalho do Windows

Veja mais: excel api vba, Excel and VBA, window capture, vba architecture, excel window, button capture, excel vba 2010, capture code excel, unwanted code, dialog box windows, excel button, solve excel problem, problem excel solve, events capture, click button handle, windows handle bug, excel problem, vba excel code 2010, workbooks, vba workbooks close, vba top, vba code click, vba close workbooks, excel bug , click button vba code

Acerca do Empregador:
( 1 comentário ) auckland, New Zealand

ID do Projeto: #2992392

Concedido a:


See private message.

$72.25 USD em 10 dias
(474 Comentários)

5 freelancers are bidding on average $30 for this job


See private message.

$25.5 USD in 10 dias
(5 Comentários)

See private message.

$8.5 USD in 10 dias
(3 Comentários)

See private message.

$8.5 USD in 10 dias
(1 Comentário)

See private message.

$34 USD in 10 dias
(0 Comentários)