Excel Guides

Ignoring Other Applications in Excel

Assuming you would like a detailed answer on how to ignore other applications when using Excel:

When working in Excel, you may want to ignore other applications so that you can focus on your work. To do this, you can use the Application.IgnoreRemoteRequests property. This property is a Boolean value that specifies whether Microsoft Excel ignores requests from other applications while it is running.

If this property is set to True, Microsoft Excel ignores requests from other applications. The default value is False. When set to False, Microsoft Excel processes requests from other applications.

You can set the Application.IgnoreRemoteRequests property in the following ways:

  • In the Visual Basic Editor, on the Tools menu, click Options, and then click the General tab.
  • In a macro, use the IgnoreRemoteRequests property as follows: Application.IgnoreRemoteRequests = True|False

Note: If you set this property to True, be sure to set it back to False. Otherwise, Microsoft Excel will continue to ignore requests from other applications.


Example 1: Ignore requests from other applications while a macro is running


The following macro uses the Application.IgnoreRemoteRequests property to prevent Microsoft Excel from processing requests from other applications while the macro is running.

Sub Macro1()
' Macro1 ignores requests from other applications.
' It also sets the calculation mode so that manual recalculation
' does not occur.
Application.Calculation = xlCalculationManual
Application.IgnoreRemoteRequests = True
    ' Place macro code here.
    ' ...
    ' Reset calculation mode and turn off ignoring of remote requests.
Application.Calculation = xlCalculationAutomatic
Application.IgnoreRemoteRequests = False
End Sub

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.