Thread
:
getting rid of the "confirm delete" dialogue box when deleting a s
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett