Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Worksheet Change Events Are Not Activated When You Click Redo

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

View products that this article applies to.

This article was previously published under Q215697

↑ Back to the top

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.

↑ Back to the top

Status

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

↑ Back to the top

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.

↑ Back to the top

Keywords: KB215697, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 215697
Revision : 6
Created on : 10/11/2006
Published on : 10/11/2006
Exists online : False
Views : 232