disable warning messages?

[Guest]

I have written a few macro's recently that take the output from Access
queries and copy the data into template spreadsheets. Depending on how large
a block of data is copied the user might get a warning about keeping the data
available to other applications on the clipboard...also get a warning when
the macro deletes some sheets from the workbook.

In Access I can turn these sorts of warnings on an off. Is there a similar
way to prevent these "breakpoints" where the user has to input a choice?

TIA

 

[Guest]

Please disregard...figured it out!

 

[ManualMan]

Yep!

Application.DisplayAlerts = False

....your code

Application.DisplayAlerts = True

This will only disable workbook-related dialogs (Save / Discard, etc).
Errordialogs generated because of misprogramming etc require a more
solid error handling. Try googling "error handling syntax vba"
Manual Man

 

[ManualMan]

Hi,

Had some problems posting this one, hope there aren't 2 answers. This
does the trick

Sub something()
Application.DisplayAlerts = False
-- some code
Application.DisplayAlerts = True
End Sub

Note: This will only prevent the usual Excel dialogs from appearing.
Error dialogs generated from VBA because of misprogramming should be
catched by more solid error handling (try "error handling syntax vba"
on google)

Regards,
ManualMan