Action Method
Showing posts with label Application Properties. Show all posts
Showing posts with label Application Properties. Show all posts
Application Worksheets Property
Purpose
For an Application object, returns a Sheets collection that represents all the worksheets in the active workbook. For a Workbook object, returns a Sheets collection that represents all the worksheets in the specified workbook. Read-only Sheets object.
Syntax
Worksheets
Application WorksheetFunction Property
Purpose
Returns the WorksheetFunction object. Read-only.
Syntax
WorksheetFunction
Application Workbooks Property
Purpose
Returns a Workbooks collection that represents all the open workbooks. Read-only.
Syntax
Workbooks
Application WindowState Property
Purpose
Returns or sets the state of the window. Read/write XlWindowState.
Syntax
WindowState
Application WindowsForPens Property
Purpose
True if the computer is running under Microsoft Windows for Pen Computing. Read-only Boolean.
Syntax
WindowsForPens
Application Windows Property
Purpose
Returns a Windows collection that represents all the windows in all the workbooks. Read-only Windows object.
Syntax
Windows
Application Width Property
Purpose
Returns or sets a Double value that represents the distance, in points, from the left edge of the application window to its right edge.
Syntax
Width
Application Watches Property
Purpose
Returns a Watches object representing a range which is tracked when the worksheet is recalculated.
Syntax
Watches
Application WarnOnFunctionNameConflict Property
Purpose
The WarnOnFunctionNameConflict property, when set to True, raises an alert if a developer tries to create a new function using an existing function name. Read/write Boolean.
Syntax
WarnOnFunctionNameConflict
Application Visible Property
Purpose
Returns or sets a Boolean value that determines whether the object is visible. Read/write.
Syntax
Visible
Application Version Property
Purpose
Returns a String value that represents the Microsoft Excel version number.
Syntax
Version
Application VBE Property
Purpose
Returns a VBE object that represents the Visual Basic Editor. Read-only.
Syntax
VBE
Application Value Property
Purpose
Returns a String value that represents the name of the application.
Syntax
Value
Application UseSystemSeparators Property
Purpose
True (default) if the system separators of Microsoft Excel are enabled. Read/write Boolean.
Syntax
UseSystemSeparators
Application UserName Property
Purpose
Returns or sets the name of the current user. Read/write String.
Syntax
UserName
Application UserLibraryPath Property
Purpose
Returns the path to the location on the user’s computer where the COM add-ins are installed. Read-only String.
Syntax
UserLibraryPath
Application UserControl Property
Purpose
True if the application is visible or if it was created or started by the user. False if you created or started the application programmatically by using the CreateObject or GetObject functions, and the application is hidden. Read/write Boolean.
Syntax
UserControl
Application UsedObjects Property
Purpose
Returns a UsedObjects object representing objects allocated in a workbook. Read-only
Syntax
UsedObjects
Subscribe to:
Posts (Atom)