Delete Without Prompt

MattLeek · March 24th, 2004, 08:34 AM

Hi,
In a Spreadsheet i'm doing, i want a sheet to be deleted but i don't want there to be a prompt. Is there a way to remove the page without it asking if you're sure you want to?

Thanks

Matthew Leek

RogerWaters · March 24th, 2004, 08:41 AM

The answer I think is to add the following line in the VB

Application.alerting = false

but remember to set set it back to true at the end of the macro

Regards
Roger

Roger Waters

RogerWaters · March 24th, 2004, 08:45 AM

sorry mis typed should be

Application.DisplayAlerts = False

Roger Waters

MattLeek · March 24th, 2004, 10:04 AM

Thanks for that it really helps!:)

Matthew Leek