Disabling Excel VBA Pop-ups...

[Joey Lichtenstein]

I have done this before, but I can't find ANYWHERE in the VBA help how I
did this.

What is the command in Excel VBA to make it not care when I want to delete
worksheets in a workbook in my code? For example, inside my code I am
trying to automate a:
ActiveWindow.SelectedSheets.Delete
And I don't want to have to deal with the OK/Cancel Window:
The selected sheet(s) will be permanantly deleted.

Thanks so much!

Joey

 

[Visual Systems AB \(Martin Arvidsson\)]

There is a property called DisplayAlerts, set this to false...

Don't forget to set it to true, when exiting excel egain...

I do think you will find it under the Excel app. object.

Regards

Martin
Arvidsson

 

[Paul B]

Joey, try 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 2002 & 2003

 

[Pierre Archambault]

Application.DisplayAlerts = False

Pierre

 

[Joey Lichtenstein]

Thanks Martin! Exactly what I was looking for!


: There is a property called DisplayAlerts, set this to false...

: Don't forget to set it to true, when exiting excel egain...

: I do think you will find it under the Excel app. object.

: Regards

: Martin
: Arvidsson

: "Joey Lichtenstein" <[email protected]> skrev i meddelandet
: :> I have done this before, but I can't find ANYWHERE in the VBA help how I
:> did this.
:>
:> What is the command in Excel VBA to make it not care when I want to delete
:> worksheets in a workbook in my code? For example, inside my code I am
:> trying to automate a:
:> ActiveWindow.SelectedSheets.Delete
:> And I don't want to have to deal with the OK/Cancel Window:
:> The selected sheet(s) will be permanantly deleted.
:>
:> Thanks so much!
:>
:> Joey