MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Disabling Message Box Prompts


Posted by Dave on August 22, 2001 9:00 AM

I'm setting up a macro that at one point deletes a temporary worksheet. How do I disable the system pop-up box so the user doesn't have to confirm the deletion of the worksheet when they run the macro?

Thx.


Posted by Dax on August 22, 2001 9:07 AM

Application.Displayalerts=False

Regards,
Dax.