Macro running multiple queries

P

Pat

I have a macro that runs several queries but I don not
want to receive the message that so many items will be
appended and then having to hit ok - Is there a way to
hide these messages and not have to say ok?

Thanks.

Pat
 
T

TPratt

At the start of the macro turn "setwarnings" to "off".

I recommend turning back to "on" at the end of macro though.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top