Vba Worksheet Change Not Working. So, your code won't work there. Tried to use the worksheet_change event to paste only values.
It will trigger when the workbook updates an external link. As you have experienced, VBA can zap the Undo stack. Let's Work Through An Example Macro.
This behavior makes sense when you observe that the cell's content isn't actually changing.
Excel Vba Worksheet Change Not Working.
First, we choose the sheet on which the event will occur. Private Sub Worksheet_Change(ByVal Target as Range) Target. I'm not sure how to post the code in here (as I think it has to be a certain way).