Thread: Bypass sheets.delete confimation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Bypass sheets.delete confimation
Hi mpeplow

Use

Application.DisplayAlerts = False
Delete code
Application.DisplayAlerts = True


--
Regards Ron de Bruin
http://www.rondebruin.nl



"mpeplow" wrote in message
...

When I use Sheets("Sheet2").Delete the macro pauses and states

there may be data blah blah do you want to delete?

How do I Tell the macro to auto click yes?


--
mpeplow
------------------------------------------------------------------------
mpeplow's Profile: http://www.excelforum.com/member.php...o&userid=34812
View this thread: http://www.excelforum.com/showthread...hreadid=569623



Reply With QuoteReply With Quote