View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kell2604 Kell2604 is offline
external usenet poster
 
Posts: 39
Default 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