View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default How do I make excel not prompt before deleting worksheets?

If you are talking about manually, there is no way around it and believe me,
one day you will be happy it does.

If this is part of a macro, use

Application.DisplayAlerts = False

before you delete the sheet and the =True after

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Lar Chen" <Lar
wrote in message
...
I am trying to delete worksheets in an excel workbook without it prompting
me
if i'm sure everytime i do this. Any ideas?