Rum macros without aletrs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
How can i run a macro without the alerts to be shown. for example, when
running a delete macro, the messages "You are about to run a delete query
that.." ,and then "You are about to delete X rows" are shown.

Thanks,
Yoav
 
Try adding "Set warnings" to the first line of your macro. This setting
should be set to "no" by default. I beleive this has the same effect as the
VBA code of "DoCmd.SetWarnings False" which will turn off all warnings.
Let me know if this works.
 
It works, thanks!
:)

Mike said:
Try adding "Set warnings" to the first line of your macro. This setting
should be set to "no" by default. I beleive this has the same effect as the
VBA code of "DoCmd.SetWarnings False" which will turn off all warnings.
Let me know if this works.
Click to expand...
 

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

Similar Threads

Run Macro If Cell have "x" value 0
Compact & Repair, Open table, close table, then run macro 3
turning off prompts??? is this possible??? 1
~tmpclpmacro 1
Stop macro after selecting 'no' 0
Turn_off confirm message"Table will be deleted" inside a Macro 2
Excel Macro for deleting Rows containing dates greater than "today" 0
Alerts disabled in DoEvents loop - Deletion of protected-locked ce 5

Back
Top