Move the line:

Application.EnableEvents=False
To immediately after the line where you set cell A8 to "Rate Indication"