Knowledge Base

XL98: Cannot Select Worksheet After Macro has Completed

Article ID: 189125

Article Last Modified on 9/11/2002

APPLIES TO

This article was previously published under Q189125

SYMPTOMS

After you run a Visual Basic for Applications macro, you may be unable to select a cell or a range of cells.

CAUSE

This problem may occur if the following conditions are true:

  • You run a Visual Basic macro that uses Automation to control another program. -and-

  • The other program uses Automation to control the current session of Microsoft Excel.

WORKAROUND

To work around this problem, follow these steps:

  1. On the Tools menu, click Preferences.
  2. To close the Preferences dialog box, click Cancel.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 98 Macintosh Edition.

Additional query words: XL98

Keywords: kbbug kbmacro kbpending KB189125


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.