Cancel Dirty Cells Highlight

Sub CancelDirtyCellsSave()

    Call DirtyCellsButtonOFF

    Call GetData

    Call ClearRangeSQL

    Range("A1").Select

End Sub

The simplest way to Cancel the Dirty Cells Highlight is to run a Refresh. That way, formats will be restored and the data is refreshed.

The only other thing is to

  • Clear the SQL UPDATE statements list
  • Turn off the Save button