XL2000: Worksheet Change Events Are Not Activated When You Click Redo (215697)



The information in this article applies to:

  • Microsoft Excel 2000

This article was previously published under Q215697

SYMPTOMS

A Worksheet or a Workbook Change event is not activated when you click Redo, although you are using a macro that should activate a Change event whenever you change the workbook or worksheet.

This behavior occurs when you follow these steps:
  1. You select a cell or cells, and then click Cut on the Edit menu.

    The Worksheet or Workbook Change event is activated.
  2. You select a cell, and then click Paste on the Edit menu.

    The Worksheet or Workbook Change event is activated.
  3. On the Edit menu, you click Undo.

    The Worksheet or Workbook Change event is activated.
  4. On the Edit menu, you click Redo.

    The Worksheet or Workbook Change event is not activated.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

REFERENCES

For more information about the Change event, click Microsoft Visual Basic Help on the Help menu, type change event in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbbug kbpending KB215697