Macro pause

[Dave]

Is there a way for a macro to open a table then pause while the table is
edited and macro resumes after table is closed?

Dave

 

[Steve Schapel]

Dave,

No, this is not possible.

In any case, it is not a good idea to open a table for editing. The
purpose of tables is data storage, and should generally be regarded as
unsuitable for human consumption in production use. Viewing, entering,
and editing of data is what forms are for. You could open a form based
on your table, edit your data, and then run the remainder of your
existing macro as a separate macro when the form is closed.