New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

stop a macro from deleting undo history

Macros, VBA, Excel Automation, etc.

stop a macro from deleting undo history

Postby sguill » Sat Jun 04, 2016 2:08 pm

I have a macro to highlight a row when we are imputing data and it does not allow undo. is there a way to keep the undo history or a better code to use.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With ThisWorkbook.Names("ActiveRow")
.Name = "ActiveRow"
.RefersToR1C1 = "=" & ActiveCell.Row
End With

End Sub


Thanks
Steve
  • 0

sguill
Rookie
 
Posts: 1
Joined: Jun 4, 2016
Reputation: 0
Excel Version: 10

Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot], Google Adsense [Bot] and 22 guests

cron