I have many buttons on my spreadsheets that run macros. Some of these
macros are searching through large data bases. As the results of these
searches are displayed in my worksheet, sometimes I can see the the
information that I was searching for and would then like to stop the
macro from running rather than searching through the rest of the
database. I would like to be able to stop the macro from running by
clicking on a professional looking stop button rather than pressing
Ctrl + Break.
Is there any VB script that can be programmed into a standard button
that will halt the macro?


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=477826