View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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