Thread
:
Warning prompts disabling
View Single Post
#
5
Posted to microsoft.public.excel.programming
Nick Hodge
external usenet poster
Posts: 1,173
Warning prompts disabling
No
My new ISP (Broadband) gave it me
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
jason wrote:
Nick
how did you get that e-mail address "zen.co.uk" - is it a business
one?
Jason
"Nick Hodge" wrote in
message ...
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
HIS
pundlik wrote:
Some processess, such as Delete a sheet, prompt a warning message
and 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
code or thru Excel settings ?
-Pundlik
email :
------------------------------------------------
~~ Message posted from
http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge