Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable warning messages?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable warning messages?
Please disregard...figured it out!
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable warning messages?
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable warning messages?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help please - warning messages | Excel Worksheet Functions | |||
Help please - warning messages | Excel Worksheet Functions | |||
Warning Messages | Excel Worksheet Functions | |||
Playing .wav files (why do a few cause warning messages?) | Excel Programming | |||
Getting rid of warning messages | Excel Programming |