The 'Private Sub Workbook_BeforeClose()' isn't running automatically (or
at all for that matter).

I've got the code in a module of it's own("B4Close") along with the
'Sub CopyData1' procedure. But when I close the Workbook it doesn't
show the MsgBox declared in 'Private Sub Workbook_BeforeClose()' but it
still shows the "Do you want to save..." dialog even tho I've stated
'...DisplayAlerts = False', also inside the 'Private Sub
Workbook_BeforeClose()'.

I haven't called the procedure from anywhere but from what I gathered,
it's not neccessary to call these particular types of procedures.

Kartune85


--
kartune85
------------------------------------------------------------------------
kartune85's Profile: http://www.excelforum.com/member.php...o&userid=35586
View this thread: http://www.excelforum.com/showthread...hreadid=555437