Search results

This would do the same thing but is a little simpler.... Private Sub Worksheet_Calculate() Application.EnableEvents = False MsgBox ("bingo") Application.EnableEvents = True End Sub The Application.EnableEvents doesn't do anything in this instance, but stops the macro feeding back...

You need to put the code in the private module for the worksheet in question. ie. Right click on the worksheet name at the bottom of your Excel workbook and select "View Code", then paste the code you have already posted and it should work.