Warning prompts disabling

  • Thread starter Thread starter pundlik
  • Start date Start date
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 : (e-mail address removed)
 
Application.DisplayAlerts = False

but remember to include Application.DisplayAlerts = True
before the end of your code.
 
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
(e-mail address removed)
 
Nick

how did you get that e-mail address "zen.co.uk" - is it a business one?

Jason
 
No

My new ISP (Broadband) gave it me

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
0oh I see
I'll just have to dream on

Jason

Nick Hodge said:
No

My new ISP (Broadband) gave it me

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
Click to expand...
 
You must log in or register to reply here.

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

Disable Security Warnings Screen 3
Disable Save 5
Hide Warnings on Save 3
Can warning messages be suppressed in Excel? 4
Notify user macros are disabled. 3
Macro warning 1
automatically deleting a worksheet (without warning prompt) 3
Deleting sheets 3

Back
Top