Disable Prompts

  • Thread starter Thread starter MatthewT
  • Start date Start date
M

MatthewT

I want to delete a worksheet as part of a VBA project. How do I disabl
the prompt asking if you are sure you want to delete it? I want t
take away this control from the user just within the project
 
Try

Application.DisplayAlerts = False
your code
Application.DisplayAlerts = True

Regards,
Alan.
 
Back
Top