XL5: Visual Basic Procedure Option Settings Not Saved

• Microsoft Excel for Windows, versions 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.

Additional query words: 5.00c macro

Keywords : kbprg
Version : WINDOWS:5.0,5.0c
Platform : WINDOWS
Issue type :