Microsoft KB Archive/183541

= XL98: VBA Macro Behavior Is Different from Excel 5.0 =

Article ID: 183541

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q183541





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.

179004 XL98: Options not Available in Macro Options Dialog Box

179005 XL98: Attached Toolbar Is Not Saved in 5.0/95 File Format

179039 XL98: Bitmap Image Shrinks When Pasted on a Toolbar Button

179328 XL98: Text Is Truncated in a Text Box with Rounded Corners

180372 XL98: Unexpected Results Paste Linking Nonadjacent Range

180642 XL98: Excel Quits When You Save a Workbook with a Module

181726 XL98: Page Setup Command Does Not Exist in Modules

181900 XL98: Some Properties and Methods Are Missing in Object Browser

182136 XL98: Error Applying Comment When Worksheets Are Grouped

182160 XL98: Structure and Windows Arguments of Protect Method

182238 XL98: Limitations for Naming Visual Basic Modules

182239 XL98: Error When Passing an Array Value Between Macros

182241 XL98: Auto_Close Macros Run When You Use Application.Quit

182295 XL98: Cannot Move or Copy Sheet After Last Sheet

182296 XL98: Overflow Error Occurs When Using Err Object

182298 XL98: Drawing Objects Behave Differently when Clicked

182299 XL98: Error Adding or Deleting a Menu Command in a Macro

182345 XL98: Visible Property Does Not Apply to All CommandBars

182408 XL98: Macro Stops Running When its Workbook Is Closed

182409 XL98: Cannot Add Macros to the Tools Menu

182410 XL98: Calling RunAutoMacros Method More than Once Fails

182480 XL98: Styles("X").Parent Different Than in Earlier Versions of Excel

182645 XL98: Problems When Disabling/Enabling Menus

182646 XL98: Cannot Paste Array Formula in its Original Cell

182647 XL98: ParamArrays are Always Zero-Based

182648 XL98: Error with Invalid Characters in Drawing Object Name

182649 XL98: ParamArray Must Be Declared as an Array of Variant

182650 XL98: No Automatic Type Coercion Between Variable Types

182717 XL98: Cannot Make Changes to Some Shortcut Menus

182718 XL98: Problems Disabling and Enabling Shortcut Menus

183539 XL98: CreateObject and GetObject Work Differently

183534 OFF98: Visual Basic Modules Cannot Be Hidden or Protected

183540 XL98: Using the MenuBars Method in Microsoft Excel 98

184174 XL98: "Type Mismatch" Comparing String Variable to Boolean

184175 XL98: "Invalid Use of Null" Error Setting OnRepeat Method

184703 XL98 Compile Error Passing ParamArray

184176 XL98: Select Method May Select More Cells Than You Expect

184704 XL98: Cannot Edit Text Box with Unlocked Text

184705 XL98: Cannot Programmatically Close Referenced Workbook

185583 XL98: Parentheses Around Object May Dereference the Object

184378 XL98: How to Delete Cells with a For Each...Next Loop

184366 XL98: Range.PasteSpecial Changes Selection

184790 XL98: Input # Statement Does Not Retain Trailing Spaces

184848 XL98: Redraw Problem Changing Visibility of Object on Dialog

184367 XL98: Type 2 Error Message Saving a Workbook or Add-In

187592 XL98: Unexpected Quit After Changing Tab Order of Option Buttons

183913 XL98: Charts.Delete Command in Macro May Delete Worksheets

154873 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: kbdtacode kbfaq kbinfo kbprb kbprogramming KB183541

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.