Changes to Visual Basic in Microsoft Excel for Windows 95

Existing properties and methods have been changed, and several new properties, methods, and objects have been added to Visual Basic in Microsoft Excel for Windows 95.

Changed Properties and Methods

The following properties and methods have been changed to support new Microsoft Excel features or to enhance existing features.

Topic	Description

GetOpenFileName Method	The new *multiSelect* argument allows you to select more than one filename in the Open dialog box.
HelpContextID Property	Added to the ToolbarButton object.
HelpFile Property	Added to the ToolbarButton object.
Names Method	Added to the Worksheet object to handle sheet-scoped names.
PasteSpecial Method	For the Range object, a new constant for the *paste* argument allows you to paste range content and formatting but not border formatting.
Protect Method	The new *userInterfaceOnly* argument allows you to specify protection from user changes while still allowing changes from Visual Basic code.
SaveAs Method	New arguments allow you to specify shared-mode access and how change conflicts are resolved.
StatusBar Property	Added to the ToolbarButton object.

AutoCorrect Support

The following new object, properties, methods have been added to support automatic corrections.

Topic	Description

AddReplacement Method	Adds a row to the array of AutoCorrect replacements returned by the ReplacementList property.
AutoCorrect Object	Contains AutoCorrect attributes (capitalization of names of days, correction of two initial capital letters, automatic correction list, and so on).
AutoCorrect Property	Returns an AutoCorrect object that represents the AutoCorrect attributes.
CapitalizeNamesOfDays Property	True if the first letters of names (and abbreviations) of days are capitalized automatically.
DeleteReplacement Method	Deletes a row from the array of AutoCorrect replacements returned by the ReplacementList property.
ReplacementList Property	Returns or sets the entire array or one row of the array of AutoCorrect replacements.
ReplaceText Property	True if text from column one of the array of AutoCorrect replacements is automatically replaced with the text from column two.
TwoInitialCapitals Property	True if occurrences of two initial capital letters in a word are corrected automatically.

OLE Document Properties Support

The following new properties, methods, and objects have been added to support OLE document properties. Document properties allow Microsoft Excel to expose a standard set of built-in document properties and additional custom document properties added by the user.

Topic	Description

BuiltinDocumentProperties Property	Returns a DocumentProperties collection object that contains the built-in document properties for the object.
CustomDocumentProperties Property	Returns a DocumentProperties collection object that contains the custom document properties for the object.
DocumentProperties Object	Represents the collection of document properties (either built-in or custom).
DocumentProperty Object	Represents a single document property.
LinkedToContent Property	True if the value of a custom property is linked to the contents of the document it's contained in; False if the property is a static value.
LinkSource Property	Specifies the source of a custom document property that's linked to document contents.

AutoComplete Support

The following method and property have been added to support the AutoComplete feature.

Topic	Description

AutoComplete Method	Returns a completed string from the list, or returns an empty string if there was no completion or if more than one entry in the list matches.
EnableAutoComplete Property	True if the AutoComplete feature is enabled.

Protection Control

The following properties have been added to allow you to control the user's ability to change toolbars, filtered lists, PivotTables, and outlining.

Topic	Description

EnableAutoFilter Property	True if AutoFilter arrows are enabled when user-interface-only protection is turned on.
EnableOutlining Property	True if outlining symbols (show detail or hide detail) are enabled when user-interface-only protection is turned on.
EnablePivotTable Property	True if PivotTable controls and actions are enabled when user-interface-only protection is turned on
Protection Property	Controls what kinds of changes the user can make to a toolbar.

Appearance Control

The following properties and methods have been added to control the appearance of the mouse pointer, turn animated insertion and deletion on and off, create a password-entry edit box, and set the background graphic for a worksheet or chart.

Topic	Description

Cursor Property	Sets the appearance of the mouse pointer in Microsoft Excel.
EnableAnimations Property	True if animated insertion and deletion is enabled.
PasswordEdit Property	Causes an edit box to display its contents as a series of asterisks.
SetBackgroundPicture Method	Sets the background graphic for a worksheet or chart.

Miscellaneous

Topic	Description

AutoLoad Property	True if the OLE object is automatically loaded when the workbook that contains the object is opened.
CopyFromRecordset Method	Copies the contents of a DAO Recordset object into cells on a worksheet, beginning at the first cell of the specified range.
ListHeaderRows Property	Returns the number of header rows for the specified range.
MoveAfterReturnDirection Property	Controls the direction in which the active cell is moved after the user presses ENTER.
NetworkTemplatesPath Property	Returns the network path where templates are stored. If the network path doesn't exist, the property returns an empty string.
OnSave Property	Returns or sets the name of a Visual Basic procedure to run whenever the user invokes the Save or Save As command.
Post Method	Posts the specified workbook to a Microsoft Exchange public folder or a Lotus Notes database.
ProtectionMode Property	True if user-interface-only protection is turned on.
RangeSelection Property	Returns a Range object that represents the selected cells on the worksheet in the specified window even if a graphic object is active or selected on the worksheet.
RefersToRange Property	Returns the Range object referred to by a Name object.
TemplatesPath Property	Returns the local path where templates are stored.