Microsoft Excel: Object Pop-up Error

[Pinaceous]

Good Day All,

I'm getting an error message in respect to:

I believe it is because if the curser is engaged upon the Excel sheet without activation, Microsoft Excel provides this pop-up.

As so:

My question is how do I prevent this from happening by way of a VBA code?

Many thanks,
pinaceous

 

[Pinaceous]

Here is another version of this error message pop-up provided by Microsoft Excel.

 

[Jaafar Tribak]

My question is how do I prevent this from happening by way of a VBA code?

The user must exit edit mode.
Is the client code that is trying to access the workbook via automation in the same machine (maybe running in another excel instance) ?

 

[Pinaceous]

The user must exit edit mode.
Is the client code that is trying to access the workbook via automation in the same machine (maybe running in another excel instance) ?

Hi Jaafar,

It appears that the client code is trying to access the workbook in the same machine.

How can this possible be prevented from happening upon the sheet, if the user forgets to exit the edit mode?

Is there a way to create a sub to force exit the edit mode upon the activation of the pop-up described above or to set it on a 60-second timer?

Thanks,
pinaceous

 

[MARK858]

Is there a way to create a sub to force exit the edit mode

AFAIK you can't run VBA when a cell is in edit mode so no.

 

[Pinaceous]

Ah I see. Do you know if I can suppress that popup somehow?

I've tried everything that I can think of in regards to

 Application.ScreenUpdating = False

ect.

Please let me know.

Thank you!
pinaceous

 

[Pinaceous]

Is there a way to tie in a vba macro when that excel pop up gets displayed?

For example, if popup gets displayed then goto cell A1?

 

[Jaafar Tribak]

How can this possible be prevented from happening upon the sheet, if the user forgets to exit the edit mode?

Take a look at the use of the CoRegisterMessageFilter api in this post

Is there a way to create a sub to force exit the edit mode upon the activation of the pop-up described above or to set it on a 60-second timer?

You can use some kind of timer such as GetTickCount and then GetLastInputInfo to monitor user inactivity but I haven't seen code that consistently forces excel to exit edit mode . This thread may be of interest to you for monitoring user inactivity.

Also, bear in mind that the automation error you are getting doesn't only happen when excel is in edit mode. It will also happen if the user leaves excel in modal mode such as when a MsgBox is left displayed on the screen or simply when a modal userform or a builtin modal dialog such as the Data validation dialog, Protect Sheet dialog, etc are left on display.