I do use a stop button on a status form in some of my macros
When a user presses the stop button, code attached to the stop butto
sets a public boolan variable.
At strategic places through out my code i place code to check if th
variable is true or false taking action as required
To prevent the macro from hanging waiting for user input when th
status form is activated i use
Private Sub UserForm_Activate()
call mymacro
End Su
--
Message posted from
http://www.ExcelForum.com