Thread: HOW TO DISABLE ALL MACROS in BeforeClose event handling procedure
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
  
Posts: 1,120
Default HOW TO DISABLE ALL MACROS in BeforeClose event handling procedure
Application.EnableEvents = False

--
HTH

Bob Phillips

"Intellihome" wrote in message
...

Hello,

Does anyone know how to set Excel to NOT to run any macros? or how to
disable all macros? I need to do it inside BeforeClose event handling
procedure...

Thank you.


--
Intellihome
------------------------------------------------------------------------
Intellihome's Profile: http://www.msusenet.com/member.php?userid=1479
View this thread: http://www.msusenet.com/t-1870532558



Reply With QuoteReply With Quote