How can i automate the response to a generated pop up?

's Computer Specifications

I need VBA code that will select OK when the popup is generated in response
to a command to delete a worksheet.

Regards

's Computer Specifications

You can turn off the pop up with the following line

Application.DisplayAlerts = False

"Eni001" wrote:

> I need VBA code that will select OK when the popup is generated in response
> to a command to delete a worksheet.
>
>
> Regards

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Disable or Automate response to StartUp Security Warnings	Alan	Microsoft Access VBA Modules	2	25th Nov 2007 12:44 PM
Automate response to protected files	Rob Oldfield	Microsoft Excel Misc	2	14th Oct 2005 11:12 PM
Schedule Meetings and Automate Response	Ray	Microsoft Outlook Calendar	1	1st May 2004 03:39 AM
request tool to automate response to registry modifications	Jose Valenzuela	Microsoft Windows 2000 Registry Archive	2	30th Jun 2003 04:53 PM
request tool to automate response to registry modifications	Jose Valenzuela	Microsoft Windows 2000 Registry Archive	0	30th Jun 2003 04:49 PM