XL98: VBA Macro Behavior Is Different from Excel 5.0

ID: Q183541

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition

SUMMARY

When you run a Visual Basic for Applications macro in Microsoft Excel 98 Macintosh Edition, the way the macro behaves may be different from the way it behaves in earlier versions of Microsoft Excel. This may be true for any of the following reasons:

The architecture of Microsoft Excel 98 Macintosh Edition is somewhat different from the architecture that is used in earlier versions of Microsoft Excel. Some elements (for example, menu bars and toolbars) are greatly enhanced in Microsoft Excel 98 Macintosh Edition. As a result, Visual Basic code that interacts with these elements may work differently.
Microsoft Excel 98 Macintosh Edition corrects some problems that are present in earlier versions of Microsoft Excel. As a result, Visual Basic code that works in earlier versions of Microsoft Excel may work differently in Microsoft Excel 98 Macintosh Edition.
Because all of the Microsoft Office programs include Microsoft Visual Basic for Applications, the Visual Basic environment in Microsoft 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 98 Macintosh Edition.

Microsoft realizes the importance of minimizing the amount of effort that is required to use macros in Microsoft Excel 98 Macintosh Edition. Microsoft Excel 98 Macintosh Edition 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 Microsoft Excel 98 Macintosh Edition.

MORE INFORMATION

Modifying your code so that it works with Microsoft Excel 98 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 Microsoft Excel 98. Wherever possible, the articles contain the information you need to modify Visual Basic macros so that they function in both Microsoft Excel 98 and in earlier versions of Microsoft Excel.

   ARTICLE-ID: Q179004
   TITLE     : XL98: Options not Available in Macro Options Dialog Box

   ARTICLE-ID: Q179005
   TITLE     : XL98: Attached Toolbar Is Not Saved in 5.0/95 File Format

   ARTICLE-ID: Q179039
   TITLE     : XL98: Bitmap Image Shrinks When Pasted on a Toolbar Button

   ARTICLE-ID: Q179328
   TITLE     : XL98: Text Is Truncated in a Text Box with Rounded
               Corners

   ARTICLE-ID: Q180372
   TITLE     : XL98: Unexpected Results Paste Linking Nonadjacent Range

   ARTICLE-ID: Q180373
   TITLE     : XL98: Cannot Change Value for Form Control on Worksheet

   ARTICLE-ID: Q180642
   TITLE     : XL98: Excel Quits When You Save a Workbook with a Module

   ARTICLE-ID: Q181726
   TITLE     : XL98: Page Setup Command Does Not Exist in Modules

   ARTICLE-ID: Q181900
   TITLE     : XL98: Some Properties and Methods Are Missing in Object
               Browser

   ARTICLE-ID: Q182136
   TITLE     : XL98: Error Applying Comment When Worksheets Are Grouped

   ARTICLE-ID: Q182160
   TITLE     : XL98: Structure and Windows Arguments of Protect Method

   ARTICLE-ID: Q182238
   TITLE     : XL98: Limitations for Naming Visual Basic Modules

   ARTICLE-ID: Q182239
   TITLE     : XL98: Error When Passing an Array Value Between Macros

   ARTICLE-ID: Q182241
   TITLE     : XL98: Auto_Close Macros Run When You Use Application.Quit

   ARTICLE-ID: Q182295
   TITLE     : XL98: Cannot Move or Copy Sheet After Last Sheet

   ARTICLE-ID: Q182296
   TITLE     : XL98: Overflow Error Occurs When Using Err Object

   ARTICLE-ID: Q182298
   TITLE     : XL98: Drawing Objects Behave Differently when Clicked

   ARTICLE-ID: Q182299
   TITLE     : XL98: Error Adding or Deleting a Menu Command in a Macro

   ARTICLE-ID: Q182345
   TITLE     : XL98: Visible Property Does Not Apply to All CommandBars

   ARTICLE-ID: Q182408
   TITLE     : XL98: Macro Stops Running When its Workbook Is Closed

   ARTICLE-ID: Q182409
   TITLE     : XL98: Cannot Add Macros to the Tools Menu

   ARTICLE-ID: Q182410
   TITLE     : XL98: Calling RunAutoMacros Method More than Once Fails

   ARTICLE-ID: Q182480
   TITLE     : XL98: Styles("X").Parent Different Than in Earlier Versions of Excel

   ARTICLE-ID: Q182645
   TITLE     : XL98: Problems When Disabling/Enabling Menus

   ARTICLE-ID: Q182646
   TITLE     : XL98: Cannot Paste Array Formula in its Original Cell

   ARTICLE-ID: Q182647
   TITLE     : XL98: ParamArrays are Always Zero-Based

   ARTICLE-ID: Q182648
   TITLE     : XL98: Error with Invalid Characters in Drawing Object
               Name

   ARTICLE-ID: Q182649
   TITLE     : XL98: ParamArray Must Be Declared as an Array of Variant

   ARTICLE-ID: Q182650
   TITLE     : XL98: No Automatic Type Coercion Between Variable Types

   ARTICLE-ID: Q182717
   TITLE     : XL98: Cannot Make Changes to Some Shortcut Menus

   ARTICLE-ID: Q182718
   TITLE     : XL98: Problems Disabling and Enabling Shortcut Menus

   ARTICLE-ID: Q183539
   TITLE     : XL98: CreateObject and GetObject Work Differently

   ARTICLE-ID: Q183534
   TITLE     : OFF98: Visual Basic Modules Cannot Be Hidden or Protected

   ARTICLE-ID: Q183540
   TITLE     : XL98: Using the MenuBars Method in Microsoft Excel 98

   ARTICLE-ID: Q184174
   TITLE     : XL98: "Type Mismatch" Comparing String Variable to
               Boolean

   ARTICLE-ID: Q184175
   TITLE     : XL98: "Invalid Use of Null" Error Setting OnRepeat
               Method

   ARTICLE-ID: Q184703
   TITLE     : XL98 Compile Error Passing ParamArray

   ARTICLE-ID: Q184176
   TITLE     : XL98: Select Method May Select More Cells Than You Expect

   ARTICLE-ID: Q184704
   TITLE     : XL98: Cannot Edit Text Box with Unlocked Text

   ARTICLE-ID: Q184705
   TITLE     : XL98: Cannot Programmatically Close Referenced Workbook

   ARTICLE-ID: Q185583
   TITLE     : XL98: Parentheses Around Object May Dereference the
               Object

   ARTICLE-ID: Q184378
   TITLE     : XL98: Deleting Cells with a For Each...Next Loop

   ARTICLE-ID: Q184366
   TITLE     : XL98: Range.PasteSpecial Changes Selection

   ARTICLE-ID: Q184790
   TITLE     : XL98: Input # Statement Does Not Retain Trailing Spaces

   ARTICLE-ID: Q184848
   TITLE     : XL98: Redraw Problem Changing Visibility of Object on
               Dialog

   ARTICLE-ID: Q184367
   TITLE     : XL98: Type 2 Error Message Saving a Workbook or Add-In

   ARTICLE-ID: Q187592
   TITLE     : XL98: Unexpected Quit After Changing Tab Order of Option
               Buttons

   ARTICLE-ID: Q183913
   TITLE     : XL98: Charts.Delete Command in Macro May Delete
               Worksheets

   ARTICLE-ID: Q154873
   TITLE     : XL: Error When You Concatenate String and Numeric Values

Additional query words: XL98 macro subroutine code fail error halt message convert conversion vba xlvbmigrate

Keywords          : kbprg kbprb kbfaq
Version           : MACINTOSH:98
Platform          : MACINTOSH
Issue type        : kbinfo

Last Reviewed: June 30, 1999