XL98: Run-Time Errors Running Macro Created in Non-English Excel

• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When you run a Visual Basic for Applications macro in Microsoft Excel 98 Macintosh Edition, you receive run-time errors.

CAUSE

This problem occurs if the Visual Basic for Applications macros were originally created in a non-English version of Excel.

WORKAROUND

To work around this problem, copy the code into a new workbook. To do this, follow these steps:

1. Click the New button on the Standard toolbar to create a new workbook.



2. Start the Visual Basic Editor (press OPTION+F11).



3. Click Project Explorer on the View menu.



4. In the Project Explorer, click the non-English workbook.



5. Click the triangle next to Modules.
   
   A list of module sheets in the non-English file is displayed.



6. Double-click one of the module sheet.
   
   A module sheet is activated.



7. On the Edit menu, click Select All.



8. On the Edit menu, click Copy.



9. Switch to the Project Explorer (press COMMAND+R).



10. In the Project Explorer window, click the new workbook that you created in step 1.



11. On the Insert menu, click Module.



12. On the Edit menu, click Paste.
    
    Repeat steps 6 through 12 for each module sheet in the workbook.

Additional query words: XL98

Keywords : kbdta xlvbainfo OffVBA xlmac
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb