Excel Question Boxes

[DB100]

Hi all

I am hoping this is an easy one

I have created a Userform that depending on the criteria entered open
a spreadhseet, make as a few changes and closes the sheets.

The problem I have is the questions that Excel asks.

Ie " Are you sure you want to delete this sheet "
" Do you want to save before closing "

Etc

Is there any way that I can not have these pop up every time

Thanks

Davi

 

[Paul B]

David, use Application.DisplayAlerts = False to turn them off, tune it back
on at the end, like this

Application.DisplayAlerts = False

'Your Code

Application.DisplayAlerts = True
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **