XL5: Visual Basic Procedure Option Settings Not Saved

The information in this article applies to:

• Microsoft Excel for Windows, version 5.0, 5.0c

SYMPTOMS

In Microsoft Excel, if you make a change in the Macro Options dialog box, such as the shortcut key assigned to a Visual Basic procedure, and if you do not make any changes to the module that contains the procedure, the change is not saved.

Note that this behavior does not occur with Microsoft Excel 4.0 macros.

CAUSE

This behavior occurs because when you change one of the options for a Visual Basic procedure, the module that contains the procedure is not marked as changed, and the change is not saved. This behavior affects the following macro options:

   Description
   Menu Item on Tools Menu
   Shortcut Key
   Function Category
   Status Bar Text
   Help Context ID

WORKAROUND

To work around this behavior, when you change one of the options listed above for a Visual Basic procedure, make a change to the module that contains the procedure (or any other module in the workbook) before you close the workbook. For example, insert a line and then delete the line, or enter a comment, and then save the workbook.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel for Windows 95, version 7.0.