Microsoft KB Archive/118800

{|
 * width="100%"|

-

The information in this article applies to:


 * 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 :
 * }