Delete a sheet

brgipple · Jun 10th 2005

I wan to delete a sheet from my workbook, and i get a question when my code deletes the sheet

here is my code:

Code

Sheets("Neg Bump").Delete

How can i have my Macro answer the question:

'The selected sheet(s) will be permanitly deleted

to delete click 'yes'
to not delete click 'no'

Thank You

**norie** · Jun 10th 2005

Re: Delete a sheet

Try this

Code

Application.DisplayAlerts = False

and this

Code

Application.DisplayAlerts = True

**royUK** · Jun 10th 2005

Re: Delete a sheet

try

Code

Application.DisplayAlerts = False
'your code
Application.DisplayAlerts = True

Participate now!