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