Bypass sheets.delete confimation

[mpeplow]

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?

[Ron de Bruin]

Hi mpeplow

Use

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


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



"mpeplow" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Ron de Bruin]

Hi mpeplow

Use

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


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



"mpeplow" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Ron de Bruin]

Hi mpeplow

Use

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


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



"mpeplow" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>