Thread: Private Sub Workbook_BeforeClose() really isn't working
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
kartune85[_21_] kartune85[_21_] is offline
external usenet poster
  
Posts: 1
Default Private Sub Workbook_BeforeClose() really isn't working

I finally figured out that I had 'Application.EnableEvents' set to
'False' so once it ran the procedure, it disabled all the events,
including Workbook_BeforeClose. Even when I reopened it, it wouldn't
run.

I set 'Application.EnableEvents = True' in 'Sub Auto_Open()' and so far
it's working everytime.


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

Reply With QuoteReply With Quote