Warning prompts disabling

P

pundlik

Some processess, such as Delete a sheet, prompt a warning message an
wait for user confirmation.
This affects the operation of a macro, especially a autorun macro.
Is there some means of eliminating these warnings, either with VB cod
or thru Excel settings ?

-Pundlik
email : [email protected]
 
K

Kevin B

Application.DisplayAlerts = False

but remember to include Application.DisplayAlerts = True
before the end of your code.
 
N

Nick Hodge

Pundlik

Add to the start of your code

Application.DisplayAlerts=False

Set it back to 'True' at the end. Excel will run the default 'answer' for
each alert created

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top