XL2000: VBA Macro Behavior Is Different from Excel 5.0 or 7.0
This article was previously published under Q180098 SUMMARY
When you run a Microsoft Visual Basic for Applications macro or procedure
in Microsoft Excel 2000, the way the macro or procedure behaves may be
different from the way it behaves in earlier versions of Excel.
This may be true for any of the following reasons:
MORE INFORMATION
Modifying your code so that it works with Excel 2000 usually
requires making only a few minor changes. The following is a list of
articles in the Microsoft Knowledge Base that address compatibility issues
in Excel 2000. Wherever possible, the articles contain the
information you need to modify Visual Basic macros and procedures so they
function in both Excel 2000 and in earlier versions of Microsoft
Excel.
213604 (http://support.microsoft.com/kb/213604/EN-US/)
XL2000: Cannot Move or Copy Sheet After Last Sheet
213603 (http://support.microsoft.com/kb/213603/EN-US/) XL2000: Overflow Error Occurs When Using Err Object 213602 (http://support.microsoft.com/kb/213602/EN-US/) XL2000: CreateObject and GetObject Work Differently 213591 (http://support.microsoft.com/kb/213591/EN-US/) XL2000: Macro Stops Running When Its Workbook Is Closed 213589 (http://support.microsoft.com/kb/213589/EN-US/) XL2000: "Type Mismatch" Comparing String Variable to Boolean 213588 (http://support.microsoft.com/kb/213588/EN-US/) XL2000: Styles("X").Parent Different Than in Earlier Versions of Excel 213567 (http://support.microsoft.com/kb/213567/EN-US/) XL2000: ParamArrays Are Always Zero-Based 213563 (http://support.microsoft.com/kb/213563/EN-US/) XL2000: Cannot Make Changes to Some Shortcut Menus 213562 (http://support.microsoft.com/kb/213562/EN-US/) XL2000: No Automatic Type Coercion Between Variable Types 213561 (http://support.microsoft.com/kb/213561/EN-US/) XL2000: Problems Disabling and Enabling Shortcut Menus 213560 (http://support.microsoft.com/kb/213560/EN-US/) XL2000: Limitations for Naming Visual Basic Modules 213556 (http://support.microsoft.com/kb/213556/EN-US/) XL2000: Error When Passing an Array Value Between Macros 213554 (http://support.microsoft.com/kb/213554/EN-US/) XL2000: "Bad DLL Calling Convention" When Running a Macro 213547 (http://support.microsoft.com/kb/213547/EN-US/) XL2000: Cannot Programmatically Close Referenced Workbook 213543 (http://support.microsoft.com/kb/213543/EN-US/) XL2000: Structure and Windows Arguments of Protect Method 213542 (http://support.microsoft.com/kb/213542/EN-US/) XL2000: Range.PasteSpecial Changes Selection 213541 (http://support.microsoft.com/kb/213541/EN-US/) XL2000: Input # Statement Does Not Retain Trailing Spaces 213540 (http://support.microsoft.com/kb/213540/EN-US/) XL2000: Run-time Error '1004' Accessing Locally Defined Name 213537 (http://support.microsoft.com/kb/213537/EN-US/) XL2000: Redraw Problem Changing Visibility of Object on Dialog 213532 (http://support.microsoft.com/kb/213532/EN-US/) XL2000: Auto_Close Macros Run When You Use Application.Quit 213530 (http://support.microsoft.com/kb/213530/EN-US/) XL2000: Error Adding or Deleting a Menu Command in a Macro 211917 (http://support.microsoft.com/kb/211917/EN-US/) XL2000: Page Setup Command Does Not Exist in Modules 213716 (http://support.microsoft.com/kb/213716/EN-US/) XL2000: Visible Property does not Apply to All CommandBars 211863 (http://support.microsoft.com/kb/211863/EN-US/) XL2000: Some Properties and Methods Are Missing in Object Browser 213705 (http://support.microsoft.com/kb/213705/EN-US/) XL2000: Can't Tile Windows with Macro If a Window Is Minimized 213703 (http://support.microsoft.com/kb/213703/EN-US/) XL2000: Error Applying Comment When Worksheets Are Grouped 213546 (http://support.microsoft.com/kb/213546/EN-US/) XL2000: Parentheses Around Object May Dereference the Object 213539 (http://support.microsoft.com/kb/213539/EN-US/) XL2000: Drawing Objects Behave Differently when Clicked 213538 (http://support.microsoft.com/kb/213538/EN-US/) XL2000: Pointer is an Hourglass When You Display a Message Box 213536 (http://support.microsoft.com/kb/213536/EN-US/) XL2000: Error Changing Order of Option Buttons on a Dialog Sheet 213544 (http://support.microsoft.com/kb/213544/EN-US/) XL2000: How to Delete Cells with a For Each...Next Loop 213557 (http://support.microsoft.com/kb/213557/EN-US/) XL2000: Cannot Edit Text Box with Unlocked Text 211499 (http://support.microsoft.com/kb/211499/EN-US/) XL2000: Text is Truncated in a Text Box with Rounded Corners 213565 (http://support.microsoft.com/kb/213565/EN-US/) XL2000: Error When Invalid Characters in Drawing Object Name 213564 (http://support.microsoft.com/kb/213564/EN-US/) XL2000: ParamArray Must be Declared as an Array of Variant 213579 (http://support.microsoft.com/kb/213579/EN-US/) XL2000: Select Method May Select More Cells Than Expected 213573 (http://support.microsoft.com/kb/213573/EN-US/) XL2000: Using "Checked", "Gray", and "Unchecked" in Macros 213570 (http://support.microsoft.com/kb/213570/EN-US/) XL2000: Reference to DAO 3.0 Changes to DAO 3.5 When File Opened 213569 (http://support.microsoft.com/kb/213569/EN-US/) XL2000: Menu Added in Wrong Position on Menu Bar 213568 (http://support.microsoft.com/kb/213568/EN-US/) XL2000: Cannot Paste Array Formula in its Original Cell 213587 (http://support.microsoft.com/kb/213587/EN-US/) XL2000: Cannot Add Macros to the Tools Menu 213783 (http://support.microsoft.com/kb/213783/EN-US/) XL2000: Compile Error Passing ParamArray 213577 (http://support.microsoft.com/kb/213577/EN-US/) XL2000: "ActiveX Component Can't Create Object" Error Using DAO 3.0 213606 (http://support.microsoft.com/kb/213606/EN-US/) XL2000: Excel Hangs When You Programmatically Save a Workbook 211552 (http://support.microsoft.com/kb/211552/EN-US/) XL2000: Attached Toolbar Is Not Saved in 5.0/95 File Format 213605 (http://support.microsoft.com/kb/213605/EN-US/) XL2000: Named Arguments Are Not Supported with DAO
| Article Translations
|
| United States | Change | | | All Microsoft Sites |
Help and Support
Back to the top
|
