Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Articles for product: Microsoft Excel 2000 Standard Edition

Article ID Article Title Hidden
213752 XL2000: Using the AddItem Method Causes an Error When RowSource Is Data Bound
213753 XL2000: Status Bar Text Not Displayed When You Point to Toolbar or Menu Item
213754 How to customize a custom toolbar button
213755 XL2000: Macro to Change File Type to "All Files (*.*)" in Open Dialog Box
213756 XL2000: Using the RemoveItem Method with ListBox or ComboBox Control
213757 XL2000: How to Turn off Shortcut Menus
213758 XL2000: Macro to Open the Most Recently Used File
213759 XL2000: How to Determine Which Items Are Selected in a List Box
213760 XL2000: How to Verify the Value of a CheckBox on a UserForm
213761 XL2000: How to Determine If a Workbook or a Worksheet Is Protected
213762 XL2000: Protect Method Password Is Not Applied to Worksheet
213763 XL2000: How to Programmatically Create a Collection
213764 XL2000: How to Programmatically Change the Project Name Property
213765 XL2000: Using a Worksheet Function in a Visual Basic Macro
213766 XL2000: Sample Macro to Remove User Name from Comment
213767 XL2000: Cannot Enable or Disable Built-in Commands with a Macro
213768 XL2000: How to Dynamically Resize a User Form
213770 XL2000: How to Create a Template for a Toolbox Control
213772 How to use system, user, and file data source names (DSN) in Excel 2000 or Excel 2002
213773 How to create data validation circles for printing in Excel
213774 XL2000: How to Create a Startup Screen with a UserForm
213775 XL2000: Edit Box Does Not Appear in Toolbox
213776 XL2000: How to Use the RefEdit Control with a UserForm
213777 XL2000: How to Play Sounds Using Visual Basic for Applications
213778 XL2000: Unexpected Behavior for RefEdit Control in Binder
213780 XL2000: How to Use Visual Basic to Create a Dynamic Chart
213781 XL2000: SaveAs Method for Worksheet Object Doesn't Save Single Ply
213783 XL2000: Compile Error Passing ParamArray
213785 XL2000: Macro Cannot Open a File That Has No Extension
213786 XL2000: Copying from the Object Browser May Not Copy Named Arguments
213787 XL2000: Problems Using Recorded Macro That Creates Map Object
213788 XL2000: Unable to Get OLE Object's Property Referencing Collection
213789 XL2000: Visual Basic Does Not Signal That an Error Has Occurred
213790 XL2000: No Menu Command to Select All Hyperlinks Within a Worksheet
213793 XL2000: How to Copy the Text Within a Text Box to a Cell
213794 XL2000: DDEREQUEST May Truncate the Results of a Query
213795 XL2000: How to Create a Monthly Calendar
213796 XL2000: How To Share a Custom AutoFill List
213797 XL2000: How to Populate an Array with a Discontiguous Range
213798 Sample Visual Basic macros for working with arrays in Excel
213799 HOW TO: Simulate a PivotTable with No Summarization in Excel 2000
213800 In Office programs, you receive a "Specified COMMAND search directory had too many parameters" error message when you try to use an MS-DOS core command from the Shell function
213801 Sample Visual Basic code to create a color index table in Excel
213802 XL2000: How to Copy Text to Text Boxes Using the Characters Method
213805 XL2000: Macros to Loop Through Range and Act Based on Cell Value
213806 XL2000: How to Close All Workbooks But One with a Visual Basic Macro
213809 XL2000: Cannot Use xlConstant Names in Variables in Visual Basic Code
213811 XL2000: How to Use DAO to Create a New Microsoft Excel Workbook
213812 XL2000: Goto Method Fails When Custom Dialog Box Is Visible
213813 XL2000: How to Add a New Category to Function Category List