Ignoring Pop Up Messages

wsf86

New Member
Joined
Oct 11, 2006
Messages
1
Hi,

New user to this site, please help!!!!

I am running a excel macro which imports data from Access and display's it in a list. This refreshes automatically ever minute. The problem I am having is that when a record is deleted from Access a pop up box appears on excel and until this is acknowledged the excel macro will not refresh.

What I need is for this pop up box to either not appear at all or if it can be auto acknowledged.

Can anyone help?

Cheers
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Watch MrExcel Video

Forum statistics

Threads
1,113,953
Messages
5,545,145
Members
410,666
Latest member
Al3cs
Top