Hi,

In one of my sheets I need to create an individual sheet with some
results.
Durisng the creation of this sheet I also create a button to close the
sheet and return to regular activity in the workbook.

All of this is done within a sub and the solution I thought was to
have a do while loop with doevent waiting for a value in a cell of
another sheet. (this value is changed when the user clicks the button)

This works pretty well, but some users are having trouble because the
button stops working, and it happens randomly.

I am not sure why Doevent stops working which effectively kills the
the macro and the user gets stuck.
It could also be that the button macro doesnt work, in either case the
running of macros has been stopped becuase the button doesnt change
the cell value as it should.
What can cause this so I can troubleshoot and find a solution?