View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default HOW TO DISABLE ALL MACROS in BeforeClose event handling procedure

"Intellihome" wrote in message
...
Application.EnableEvents works only for that line where it is executed.

VBA goes to the next line and it switches EnableEvents back to True. So
this does not work.


Completely incorrect!

--

Vasant