ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problems with the OnWorkbookClose() Event (https://www.excelbanter.com/excel-programming/392951-problems-onworkbookclose-event.html)

[email protected]

Problems with the OnWorkbookClose() Event
 
Hi all

Im trying to prevent the OnWorkbookClose() event from running by
setting the cancel flag to true, however after this the program just
hangs for until i stop the debugger.

Current Code is...

STDMETHODIMP CAppEventListener::HandleBeforeWorkbookClose(IDisp atch*
xlBook, VARIANT_BOOL* fCancel)
{
*fCancel = VARIANT_TRUE;
HRESULT hr = S_OK;
return hr;
}

I cant see exactly where the problem is but im sure its in this
function somewhere. This function is called when the
BeforeWorkbookClose() Event is fired.

Any help you guys might be able to offer would be greatly apreicated

Joel


[email protected]

Problems with the OnWorkbookClose() Event
 
Bump


[email protected]

Problems with the OnWorkbookClose() Event
 

Bump...again



All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com