Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help - Suppress warning box
I'm writing a macro and deleting a worksheet. How can I suppress th
warning box for the user about deleting the worksheet? Thanks, Stev -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help - Suppress warning box
Application.DisplayAlerts = False 'turn off warnings
Application.DisplayAlerts = True 'turn on warnings HTH -- Michael J. Malinsky Pittsburgh, PA "I am a bear of very little brain, and long words bother me." -- AA Milne, Winnie the Pooh "ssmith " wrote in message ... I'm writing a macro and deleting a worksheet. How can I suppress the warning box for the user about deleting the worksheet? Thanks, Steve --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help - Suppress warning box
Application.DisplayAlerts = False
'Your Code Application.DisplayAlerts = True -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 97 & 2000 ** remove news from my email address to reply by email ** "ssmith " wrote in message ... I'm writing a macro and deleting a worksheet. How can I suppress the warning box for the user about deleting the worksheet? Thanks, Steve --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help - Suppress warning box
Hi Steve...
I'm writing a macro and deleting a worksheet. How can I suppress the warning box for the user about deleting the worksheet? This should do it.. ....In front of your sheet deletion Application.Displayalerts = False delete your sheet<<<<<<<< .....After your sheet deletion Application.Displayalerts = True Hope that does it for you.. seeya ste |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
suppress warning and locate cube in a pivot table from olap cube | Excel Discussion (Misc queries) | |||
How to suppress scroll window action when recording macro | Excel Discussion (Misc queries) | |||
How can I suppress prompts during macro run? | Excel Discussion (Misc queries) | |||
within a macro how can I suppress the warning pop "A file named xxxx.xls already exists in this location. Do you want to replace it?" | Excel Programming | |||
Unable to suppress warning message... | Excel Programming |