Deactivation of autorun macros

[Robert X]

Hello,
I have a ProjectBeforeTaskChange macro in a module. Is it possible to run
another macro which will deactivate temporarily this autorun macro, during
its own process ?
Thanks for your help.

Robert

 

[Rod Gill]

Hi,

No, but there is another way around this. Create a Global variable called
NoInterrupts as a Boolean variable. At the beginning of each interrupt
code:
If NoInterrupts then
exit Sub
End If
NoInterrupts=True

'Interrupt code

NoInterrupts=False
End Sub

This way the interrupt only runs once and no other interrupt is triggered
until the NoInterrupts flag is set to False.
--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[Robert X]

Thanks Rod : that worked !

Another similar problem:
The ProjectBeforeTaskChange macro is fired each time the user clicks on the
Save button. Is it possible to lock this strange trigger?
Thanks again

Robert