View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default getting rid of the "confirm delete" dialogue box when deleting a s


application.displayalerts=false
code
reset to true
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bernard" wrote in message
...
I have a workbook with thousands of sheets and want to use a macro to
delete
selected sheets. Problem is the macro is stopped to "The selected sheet
will
be permanently deleted, please confirm delete.............".
Can this dialogue box be turned off permanently?
thanks
Bernard.