Exit EditMode of a second Excel Instance from Current Application

Jaafar Tribak

Well-known Member
Joined
Dec 5, 2002
Messages
8,253
Office Version
  1. 2016
Platform
  1. Windows
Tom showed here a nice way to force excel out of edit mode via a Windows timer. I want to extend this so it can be performed on a second running instance of excel .

I guess this should be fairly easy to do by activating the second instance and sending the appropriate key/mouse strokes/clicks.However, this wouldn't be an elegant way as this would desactivate the current application by bringing the second instance window to the forground .

Now, if the current application could first check if the second application is in edit mode and if so exit the edit mode discretely behind the scenes that would nicely prevent any cross-data communication code getting stuck .

Any thoughts on how this could possibly be achieved?

Regards.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,136,328
Messages
5,675,136
Members
419,551
Latest member
thangxpm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top