how to delete a spreadsheet witout to be asked yes or no

  • Thread starter Thread starter yosi_lb
  • Start date Start date
Y

yosi_lb

hi all

I have a procedure in visualbasic that delets spreadsheets from Excel
workbook.
if there's data on the spreadsheet, Excel is asking to confim the delete
operation by a yes/no message box.

how can I make to delete the spreadsheet automaticaly without to confirm ?

thanks
 
yosi

Application.DisplayAlerts=False

and True at the end of your code or any possible exit point

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
 
Back
Top