Disable esc key while calling the macro

[Chandresh]

HI all,

Need a help to disable the Escape key while running a macro.

I am calling all the macro by below code is there any way I can disable "esc" key so that no one can interrupt the running macro.

Sub EveryThing()
Call Clear
Call CSV
Call Lookup1
Call RefreshAllPivotTables
End Sub

Thanks
Chandresh

 

[RoryA]

Look up Application.enablecancelkey in the Help. Make sure to reset it at the end of the code!