XL2000: VBA Macro Behavior Is Different from Excel 5.0 or 7.0

• Microsoft Excel 2000

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:

• The architecture of Excel 2000 is somewhat different from the architecture that is used in earlier versions of Excel. Some elements (for example, menu bars and toolbars) are greatly enhanced in Excel 2000. As a result, Visual Basic code that interacts with these elements may work differently.



• Excel 2000 corrects some problems that are present in earlier versions of Excel. As a result, Visual Basic code that works in earlier versions of Excel may work differently in Excel 2000.



• Because all of the Microsoft Office programs include Visual Basic for Applications, the Visual Basic environment in Excel includes changes that accommodate the new programs and provide consistent behavior in all programs. As a result, code that uses automation or other cross-product functionality may work differently in Microsoft Excel 2000.



• Microsoft realizes the importance of minimizing the amount of effort that is required to use Visual Basic macros and procedures in Excel. Excel 2000 is designed to be compatible with earlier versions of Microsoft Excel; however, in some cases, it may be necessary to modify your code so that it works in Excel 2000.

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.

Q213604 XL2000: Cannot Move or Copy Sheet After Last Sheet

Q213603 XL2000: Overflow Error Occurs When Using Err Object

Q213602 XL2000: CreateObject and GetObject Work Differently

Q213591 XL2000: Macro Stops Running When Its Workbook Is Closed

Q213589 XL2000: "Type Mismatch" Comparing String Variable to Boolean

Q213588 XL2000: Styles("X").Parent Different Than in Earlier Versions of Excel

Q213567 XL2000: ParamArrays Are Always Zero-Based

Q213563 XL2000: Cannot Make Changes to Some Shortcut Menus

Q213562 XL2000: No Automatic Type Coercion Between Variable Types

Q213561 XL2000: Problems Disabling and Enabling Shortcut Menus

Q213560 XL2000: Limitations for Naming Visual Basic Modules

Q213556 XL2000: Error When Passing an Array Value Between Macros

Q213554 XL2000: "Bad DLL Calling Convention" When Running a Macro

Q213547 XL2000: Cannot Programmatically Close Referenced Workbook

Q200790 XL2000: Crash Saving Workbook If Module Name Contains Equal Sign

Q213543 XL2000: Structure and Windows Arguments of Protect Method

Q213542 XL2000: Range.PasteSpecial Changes Selection

Q213541 XL2000: Input # Statement Does Not Retain Trailing Spaces

Q213540 XL2000: Run-time Error '1004' Accessing Locally Defined Name

Q213537 XL2000: Redraw Problem Changing Visibility of Object on Dialog

Q213532 XL2000: Auto_Close Macros Run When You Use Application.Quit

Q213530 XL2000: Error Adding or Deleting a Menu Command in a Macro

Q211917 XL2000: Page Setup Command Does Not Exist in Modules

Q213716 XL2000: Visible Property does not Apply to All CommandBars

Q211863 XL2000: Some Properties and Methods Are Missing in Object Browser

Q213705 XL2000: Can't Tile Windows with Macro If a Window Is Minimized

Q213703 XL2000: Error Applying Comment When Worksheets Are Grouped

Q213546 XL2000: Parentheses Around Object May Dereference the Object

Q213539 XL2000: Drawing Objects Behave Differently when Clicked

Q213538 XL2000: Pointer is an Hourglass When You Display a Message Box

Q213536 XL2000: Error Changing Order of Option Buttons on a Dialog Sheet

Q213544 XL2000: Deleting Cells While In a For Each Loop

Q213557 XL2000: Cannot Edit Text Box with Unlocked Text

Q211499 XL2000: Text is Truncated in a Text Box with Rounded Corners

Q213565 XL2000: Error When Invalid Characters in Drawing Object Name

Q213564 XL2000: ParamArray Must be Declared as an Array of Variant

Q213579 XL2000: Select Method May Select More Cells Than Expected

Q213573 XL2000: Using "Checked", "Gray", and "Unchecked" in Macros

Q213570 XL2000: Reference to DAO 3.0 Changes to DAO 3.5 When File Opened

Q213569 XL2000: Menu Added in Wrong Position on Menu Bar

Q213568 XL2000: Cannot Paste Array Formula in its Original Cell

Q213587 XL2000: Cannot Add Macros to the Tools Menu

Q213783 XL2000: Compile Error Passing ParamArray

Q213577 XL2000: "ActiveX component can't create object." Error Using DAO 3.0

Q213606 XL2000: Excel Hangs When You Programmatically Save a Workbook

Q211552 XL2000: Attached Toolbar Is Not Saved in 5.0/95 File Format

Q213605 XL2000: Named Arguments Are Not Supported with DAO

Additional query words: subroutine vba code fail error halt message convert conversion XL2000

Keywords : kbprg
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbhowto