application.alertdisplay - does not work without application.

[lezawang]

Hi
I removed application from the second line like this

 DisplayAlerts = False

but that did not work, excel gave me the warning. Why I need to add Application.
in this case? because with workbooks, I do not need to add Application.
So I can say

 workbooks.add

instead of

 application.workbooks.add

but that is not the case with DisplayAlerts. Thank you very much.

Sub deletesheet()
    Application.DisplayAlerts = False
    Dim x As Integer
    x = InputBox("enter sheet#")
    Workbooks(1).Worksheets(x).Delete
    Application.DisplayAlerts = True
End Sub

 

[DanteAmor]

But what is the problem?
To add books there are no warnings.
But to delete if there is warning, to avoid the warning you can use
Application.DisplayAlerts = False

 

[MARK858]

From Microsoft.com

Many of the properties and methods that return the most common user-interface objects, such as the active cell (ActiveCell property), can be used without the Application object qualifier. For example, instead of writing:

Application.ActiveCell.Font.Bold = True
You can write:

ActiveCell.Font.Bold = True

 

[lezawang]

No what I meant, I can not use "Application.DisplayAlerts = False" without typing "Application."
In another words, if I do this line of code, it wont work

 DisplayAlerts = False

The adding workbook was just an example. Thank you once again

But what is the problem?
To add books there are no warnings.
But to delete if there is warning, to avoid the warning you can use
Application.DisplayAlerts = False

 

[DanteAmor]

Some properties of the application require the expression: Application. In this case it is necessary to put Application to work.