Delete Sheets

[Andibevan]

Hi All,

When I use the following formula:-

Thisworkbook.sheets("Sheet1").delete

It asks me whether I want to delete the sheet - Is there any way of
bypassing this?

Ta

Andi

[keepITcool]

application.displayalerts=false

resets autom when macro is done.




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Andibevan wrote :

> Hi All,
>
> When I use the following formula:-
>
> Thisworkbook.sheets("Sheet1").delete
>
> It asks me whether I want to delete the sheet - Is there any way of
> bypassing this?
>
> Ta
>
> Andi

[Dave Peterson]

application.displayalerts = false
Thisworkbook.sheets("Sheet1").delete
application.displayalerts = true

Andibevan wrote:
>
> Hi All,
>
> When I use the following formula:-
>
> Thisworkbook.sheets("Sheet1").delete
>
> It asks me whether I want to delete the sheet - Is there any way of
> bypassing this?
>
> Ta
>
> Andi

--

Dave Peterson

[Doug]

Hi

You want it to say


Application.DisplayAlerts=False
Thisworkbook.sheets("Sheet1").delete
Application.DisplayAlerts=True


Doug

Andibevan wrote in message ...
>Hi All,
>
>When I use the following formula:-
>
>Thisworkbook.sheets("Sheet1").delete
>
>It asks me whether I want to delete the sheet - Is there any way of
>bypassing this?
>
>Ta
>
>Andi
>
>