Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to bypass pop-up box
Hi Guys -
I have a macro, one of the steps deletes a sheet in my workbook. This macro will be on a server and running at a specific time each day. My problem is the action of deleting the sheet causes excel to promt me "Am I sure I want to delete, yada yada?". Is there a way to tell this macro to automatically answer yes to the prompt...as a real person will not be around to answer the question?? Thanks very much!! Kelley |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to bypass pop-up box
Hi,
application.displayalerts=false delete your worksheet application.displayalerts=true Mike "Kell2604" wrote: Hi Guys - I have a macro, one of the steps deletes a sheet in my workbook. This macro will be on a server and running at a specific time each day. My problem is the action of deleting the sheet causes excel to promt me "Am I sure I want to delete, yada yada?". Is there a way to tell this macro to automatically answer yes to the prompt...as a real person will not be around to answer the question?? Thanks very much!! Kelley |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to bypass pop-up box
Thanks Mike that worked!!
What if I'm opening a workboot that is locked for editing or password protected and I want to say YES to the prompt that asks if I want to open the workbook in read only? "Mike H" wrote: Hi, application.displayalerts=false delete your worksheet application.displayalerts=true Mike "Kell2604" wrote: Hi Guys - I have a macro, one of the steps deletes a sheet in my workbook. This macro will be on a server and running at a specific time each day. My problem is the action of deleting the sheet causes excel to promt me "Am I sure I want to delete, yada yada?". Is there a way to tell this macro to automatically answer yes to the prompt...as a real person will not be around to answer the question?? Thanks very much!! Kelley |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bypass a function in a Macro | Excel Discussion (Misc queries) | |||
Bypass Auto_open Macro in Excel 2007 | Excel Discussion (Misc queries) | |||
Macro security bypass for one application | Excel Programming | |||
Macro to bypass password pop up alert | Excel Programming | |||
Oblect not found in macro - bypass | Excel Programming |