Delete Sheets
 

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

Delete Sheets
 

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

Delete Sheets
 

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

Delete Sheets
 

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