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

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

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