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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yosi_lb - 27 Dec 2006 07:50 GMT

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

Reply to this Message

Nick Hodge - 27 Dec 2006 09:39 GMT

yosi

Application.DisplayAlerts=False

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

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk

> hi all
>
[quoted text clipped - 6 lines]
>
> thanks

Reply to this Message

yosi_lb - 27 Dec 2006 20:14 GMT

thank you very much

> yosi
>
[quoted text clipped - 13 lines]
>>
>> thanks

Reply to this Message