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

[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

 

[Nick Hodge]

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

 

[yosi_lb]

thank you very much

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