I'm hoping someone can identify the issue here:
I have this code in the ThisWorkbook module:
But the event doesn't cancel.Please Login or Register to view this content.
I get the msgbox so I know that the If statement is good.
When I step through and debug the value of Cancel before the code sets it to True, the value is False (as expected). After the code sets it to True and I debug the value of Cancel, the value is True (as expected).
But the event is never cancelled and the workbook always closes.
I have also tried using ByRef in the parameters for the procedure but nada.
Driving me insane!
Bookmarks