Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Warning prompts disabling
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 : ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Warning prompts disabling
Application.DisplayAlerts = False
but remember to include Application.DisplayAlerts = True before the end of your code. -----Original Message----- 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/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Warning prompts disabling
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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Warning prompts disabling
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/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Warning prompts disabling
0oh I see
I'll just have to dream on Jason "Nick Hodge" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Prompts | Excel Discussion (Misc queries) | |||
Disabling Macro Warning | Excel Discussion (Misc queries) | |||
Excel hyperlinks - disabling warning messages | Links and Linking in Excel | |||
Saving Prompts | Excel Worksheet Functions | |||
Prompts | Excel Discussion (Misc queries) |