|
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 |
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/ . |
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/ |
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/ |
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/ |
| All times are GMT +1. The time now is 05:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com