Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Office 2010
Excel 2010
Excel 2010 Primary Interop Assembly Reference
Class Library
Microsoft.Office.Interop.Excel Namespace
_Application Interface
_Application Properties
_Default Property
ActiveCell Property
ActiveChart Property
ActiveDialog Property
ActiveEncryptionSession Property
ActiveMenuBar Property
ActivePrinter Property
ActiveProtectedViewWindow Property
ActiveSheet Property
ActiveWindow Property
ActiveWorkbook Property
AddIns Property
AddIns2 Property
AlertBeforeOverwriting Property
AltStartupPath Property
AlwaysUseClearType Property
AnswerWizard Property
Application Property
ArbitraryXMLSupportAvailable Property
AskToUpdateLinks Property
Assistance Property
Assistant Property
AutoCorrect Property
AutoFormatAsYouTypeReplaceHyperlinks Property
AutomationSecurity Property
AutoPercentEntry Property
AutoRecover Property
Build Property
CalculateBeforeSave Property
Calculation Property
CalculationInterruptKey Property
CalculationState Property
CalculationVersion Property
Caller Property
CanPlaySounds Property
CanRecordSounds Property
Caption Property
CellDragAndDrop Property
Cells Property
Charts Property
ClipboardFormats Property
ClusterConnector Property
ColorButtons Property
Columns Property
COMAddIns Property
CommandBars Property
CommandUnderlines Property
ConstrainNumeric Property
ControlCharacters Property
CopyObjectsWithCells Property
Creator Property
Cursor Property
CursorMovement Property
CustomListCount Property
CutCopyMode Property
DataEntryMode Property
DDEAppReturnCode Property
DecimalSeparator Property
DefaultFilePath Property
DefaultSaveFormat Property
DefaultSheetDirection Property
DefaultWebOptions Property
DeferAsyncQueries Property
Dialogs Property
DialogSheets Property
DisplayAlerts Property
DisplayClipboardWindow Property
DisplayCommentIndicator Property
DisplayDocumentActionTaskPane Property
DisplayDocumentInformationPanel Property
DisplayExcel4Menus Property
DisplayFormulaAutoComplete Property
DisplayFormulaBar Property
DisplayFullScreen Property
DisplayFunctionToolTips Property
DisplayInfoWindow Property
DisplayInsertOptions Property
DisplayNoteIndicator Property
DisplayPasteOptions Property
DisplayRecentFiles Property
DisplayScrollBars Property
DisplayStatusBar Property
Dummy101 Property
EditDirectlyInCell Property
EnableAnimations Property
EnableAutoComplete Property
EnableCancelKey Property
EnableEvents Property
EnableLargeOperationAlert Property
EnableLivePreview Property
EnableSound Property
EnableTipWizard Property
ErrorCheckingOptions Property
Excel4IntlMacroSheets Property
Excel4MacroSheets Property
ExtendList Property
FeatureInstall Property
FileConverters Property
FileDialog Property
FileExportConverters Property
FileFind Property
FileSearch Property
FileValidation Property
FileValidationPivot Property
FindFormat Property
FixedDecimal Property
FixedDecimalPlaces Property
FormulaBarHeight Property
GenerateGetPivotData Property
GenerateTableRefs Property
Height Property
HideChartDraftModeNotification Property
HighQualityModeForGraphics Property
Hinstance Property
HinstancePtr Property
Hwnd Property
IgnoreRemoteRequests Property
InsertChartInDraftMode Property
Interactive Property
International Property
IsSandboxed Property
Iteration Property
LanguageSettings Property
LargeButtons Property
LargeOperationCellThousandCount Property
Left Property
LibraryPath Property
MailSession Property
MailSystem Property
MapPaperSize Property
MathCoprocessorAvailable Property
MaxChange Property
MaxIterations Property
MeasurementUnit Property
MemoryFree Property
MemoryTotal Property
MemoryUsed Property
MenuBars Property
Modules Property
MouseAvailable Property
MoveAfterReturn Property
MoveAfterReturnDirection Property
MultiThreadedCalculation Property
Name Property
Names Property
NetworkTemplatesPath Property
NewWorkbook Property
ODBCErrors Property
ODBCTimeout Property
OLEDBErrors Property
OnCalculate Property
OnData Property
OnDoubleClick Property
OnEntry Property
OnSheetActivate Property
OnSheetDeactivate Property
OnWindow Property
OperatingSystem Property
OrganizationName Property
Parent Property
Path Property
PathSeparator Property
PivotTableSelection Property
PreviousSelections Property
PrintCommunication Property
ProductCode Property
PromptForSummaryInfo Property
ProtectedViewWindows Property
Quitting Property
Range Property
Ready Property
RecentFiles Property
RecordRelative Property
ReferenceStyle Property
RegisteredFunctions Property
ReplaceFormat Property
RollZoom Property
Rows Property
RTD Property
SaveISO8601Dates Property
ScreenUpdating Property
Selection Property
Sheets Property
SheetsInNewWorkbook Property
ShortcutMenus Property
ShowChartTipNames Property
ShowChartTipValues Property
ShowDevTools Property
ShowMenuFloaties Property
ShowSelectionFloaties Property
ShowStartupDialog Property
ShowToolTips Property
ShowWindowsInTaskbar Property
SmartArtColors Property
SmartArtLayouts Property
SmartArtQuickStyles Property
SmartTagRecognizers Property
Speech Property
SpellingOptions Property
StandardFont Property
StandardFontSize Property
StartupPath Property
StatusBar Property
TemplatesPath Property
ThisCell Property
ThisWorkbook Property
ThousandsSeparator Property
Toolbars Property
Top Property
TransitionMenuKey Property
TransitionMenuKeyAction Property
TransitionNavigKeys Property
UILanguage Property
UsableHeight Property
UsableWidth Property
UseClusterConnector Property
UsedObjects Property
UserControl Property
UserLibraryPath Property
UserName Property
UseSystemSeparators Property
Value Property
VBE Property
Version Property
Visible Property
WarnOnFunctionNameConflict Property
Watches Property
Width Property
Windows Property
WindowsForPens Property
WindowState Property
Workbooks Property
WorksheetFunction Property
Worksheets Property
Expand Minimize
This topic has not yet been rated - Rate this topic

_Application.DataEntryMode Property

Office 2010

Returns or sets Data Entry mode, as shown in the table below. When in Data Entry mode, you can enter data only in the unlocked cells in the currently selected range.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
C#
VB
Copy 
int DataEntryMode { get; set; }

Property Value

Type: System.Int32

Value

Meaning

xlOn

Data Entry mode is turned on.

xlOff

Data Entry mode is turned off.

xlStrict

Data Entry mode is turned on and pressing ESC won't turn it off.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.