Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you bypass excel generated pop ups.
I am using a macro to delete sheets. I don't want excel
to ask if you are sure if you want to delete the sheets. Is there anyway to make the prompt boxes stop popping up? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you bypass excel generated pop ups.
wandering, use this
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 2000 & 97 ** remove news from my email address to reply by email ** "Wandering Mage" wrote in message ... I am using a macro to delete sheets. I don't want excel to ask if you are sure if you want to delete the sheets. Is there anyway to make the prompt boxes stop popping up? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you bypass excel generated pop ups.
Awesome, great and quick help from all of you as usual!
Thank you. -----Original Message----- wandering, use this 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 2000 & 97 ** remove news from my email address to reply by email ** "Wandering Mage" wrote in message ... I am using a macro to delete sheets. I don't want excel to ask if you are sure if you want to delete the sheets. Is there anyway to make the prompt boxes stop popping up? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bypass unlocked cell on protected worksheet in Excel 2003? | Excel Discussion (Misc queries) | |||
Bypass Auto_open Macro in Excel 2007 | Excel Discussion (Misc queries) | |||
any way to bypass Excel Limit of 255 rows? | Charts and Charting in Excel | |||
excel.exe has generated errors | Excel Discussion (Misc queries) | |||
Excel.exe has generated errors | New Users to Excel |